Reports exported as Excel cannot be read by Mac version of Excel

I searched the list but did not see anything related.

I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open.

I cannot export the report as CSV as it will not correctly import into Excel on the Mac.

Is there a work around for this?

Thanks.

--seani have the exact same problem. the excel files open on windows fine, but on the mac they crash excel. if you start excel and then use file-> open, it just hangs.|||

I am also having this problem with users trying to open the xlm file created from RS and using a MAC. Please let us know what is causing this problem and how to correct it.

I will note the spreadsheet did open for the user when they used EXCEL 98, but doesn't work with EXCEL 2001 or EXCEL 2004.

I found this http://support.microsoft.com/kb/918529 . It fixes 2005 SQL server but I see nothing for SQL server 2000.

Thanks.

|||

Hey, I'm also have this problem, I read that the SP2 of SQL Server 2005 fix this problem, but we are having some problems with SSAS and the SP2, so we can't install it.

Doe's any one installed the fix mentioned in the post above? ... Any troubles? ... Thanks!

|||We installed SP2 and low and behold the problem is gone. Our MAC users are very happy.

Thanks.

--sean