Windows Excel Doc displays html/xml code in '04/'08

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

OfficeUser@officeformac.com - 22 Apr 2008 21:19 GMT

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hi,

This occurs in Office 2004 or 2008, both with the latest updates. This occurs in either Leopard or Tiger - also with the latest updates:

An Excel document that was created in (PC) Office 2003 with .xls extension will not open properly in the Mac version of Excel. The document will open & display properly in Office 2007 or 2003.

Here is a snippet of the first several lines of the file as displayed on the Mac:

* **Begin Snippet***

MIME-Version: 1.0
X-Document-Type: Workbook
Content-Type: multipart/related; boundary="sheet-boundary"

#NAME?
Content-Location: file:///C:/temp/book.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="unicode"

<html xmlns:v=3D"urn:schemas-microsoft-com:vml"
xmlns:o=3D"urn:schemas-microsoft-com:office:office"
xmlns:x=3D"urn:schemas-microsoft-com:office:excel"
xmlns=3D"http://www.domain.com <http://www.domain.com>">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dutf-8">

* ***End Snippet****

There are several more lines of header information, followed by a lot of formatting ifo that has the following structure:

* **Begins Snippet*** .xl35
{mso-style-parent:style0;
font-family:Times New Roman;
text-align:left;
vertical-align:middle;
white-space:normal;
border-left:.5pt solid #c0c0c0;
border-top:none;
border-right:none;
border-bottom:.5pt solid #c0c0c0;
}
* **End Snippet***

Thanks for any advice!

Bob

Reply to this Message

Bob Greenblatt - 22 Apr 2008 21:33 GMT

On 4/22/08 4:19 PM, in article ee9945d.-1@webcrossing.caR9absDaxw,

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
[quoted text clipped - 51 lines]
>
> Bob

Looks to me as though the windows user saved the file as HTML and then
changed the extension to xls.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

OfficeUser@officeformac.com - 01 May 2008 20:03 GMT

Hi Bob,

Thanks for your reply. I agree, this looks like some sort of html/xml code, but I'm confused as to why this would open perfectly in PC Excel 2003/2007...I mean the same file opens & displays correctly on the PC version but not in the Mac version (2004/2008). This eliminates the possibility of a mis-saved document.

Thanks,

Bob

> On 4/22/08 4:19 PM, in article ee9945d.-1@webcrossing.caR9absDaxw,
> "OfficeUser@officeformac.com" wrote:
[quoted text clipped - 57 lines]
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom

Reply to this Message

Bob Greenblatt - 01 May 2008 21:29 GMT

On 5/1/08 3:03 PM, in article ee9945d.1@webcrossing.caR9absDaxw,

> Hi Bob,
>
[quoted text clipped - 7 lines]
>
> Bob

Well, not necessarily. There usually is an associated folder of other html
stuff which may be on the windows machine and not on the Mac.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / May 2008

Windows Excel Doc displays html/xml code in '04/'08