Exporting Reporting Services Excel file on a MAC

[MacUser]

I have a report that I have to render in Excel, I have created the report
using Reporting Services. When I try to open the output Excel file, I get the
Error message " Application Excel quit unexpectedly' and I am not able to
view the Excel file on MAC. Windows works just fine. The file size is only
about 100kb.

Any suggestions

 

[Jim Gordon MVP]

Hi,

What is the file format that Reporting Services creates? Is it xls or some
other format.

What version of Excel do you use? Have you installed all updates for your
copy of Excel?

Does the exact same file cause a crash on any other computer besides yours?

-Jim Gordon
Mac MVP

I have a report that I have to render in Excel, I have created the report
using Reporting Services. When I try to open the output Excel file, I get the
Error message " Application Excel quit unexpectedly' and I am not able to
view the Excel file on MAC. Windows works just fine. The file size is only
about 100kb.

Any suggestions

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[MacUser]

Reporting Services created a .xls file on the mac machine. We have Microsoft
Office 2004 installed on the mac machine.

I get this error message "" Microsoft Excel has unexpectedly quit."

Using Reporting Services 2000.

If I export to Excel on my windows PC, open the file and save it and then
open in
Mac it opens without errors.
However if I just open the file without saving it does not open the .xls file.

When Reporting Services renders in Excel format, what version of Excel does
it use?
Is it the one installed on the client machine?

Thanks in Advance

 

[MacUser]

I am using Office 2004 11.3.3 Reproting Services with Sp2

 

[Jim Gordon MVP]

Hi,

My guess is that the file created by Reporting Services is corrupt in a way
that Windows Excel doesn't notice but Mac Excel does.

However, it could be something on your mac totally separate from Excel
itself that needs attention. MVP John McGimpsey has a page of things to
check. You can read it here:
http://www.mcgimpsey.com/macoffice/office/troubleshooting.html

Start at the top of the list and work your way down trying after each thing
to see whether or not that changed the situation. I would add one additional
item to John's list. After "check your settings" I would run Alsoft
DiskWarrior version 4.

My hunch is that Reporting Services is creating a badly constructed file in
the first place. But you won't know for sure until after you've tested the
things in John's list. Excel 2004 is not known to quit unexpectedly very
often.

-Jim Gordon
Mac MVP

I am using Office 2004 11.3.3 Reproting Services with Sp2

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[MacUser]

Jim,

It does'nt happen for just one file, but any Excel file exported from
Reporting Services.
I will try your suggestions and let you know if it works.

Thanks

Hi,

My guess is that the file created by Reporting Services is corrupt in a way
that Windows Excel doesn't notice but Mac Excel does.

However, it could be something on your mac totally separate from Excel
itself that needs attention. MVP John McGimpsey has a page of things to
check. You can read it here:
http://www.mcgimpsey.com/macoffice/office/troubleshooting.html

Start at the top of the list and work your way down trying after each thing
to see whether or not that changed the situation. I would add one additional
item to John's list. After "check your settings" I would run Alsoft
DiskWarrior version 4.

My hunch is that Reporting Services is creating a badly constructed file in
the first place. But you won't know for sure until after you've tested the
things in John's list. Excel 2004 is not known to quit unexpectedly very
often.

-Jim Gordon
Mac MVP

I am using Office 2004 11.3.3 Reproting Services with Sp2

Hi,

What is the file format that Reporting Services creates? Is it xls or some
other format.

What version of Excel do you use? Have you installed all updates for your
copy of Excel?

Does the exact same file cause a crash on any other computer besides yours?

-Jim Gordon
Mac MVP


Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:

I have a report that I have to render in Excel, I have created the report
using Reporting Services. When I try to open the output Excel file, I get
the
Error message " Application Excel quit unexpectedly' and I am not able to
view the Excel file on MAC. Windows works just fine. The file size is only
about 100kb.

Any suggestions

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[MacUser]

Jim,

Also, it does'nt happen on just one Mac machine. Happens on all of them.

Thanks

Hi,

My guess is that the file created by Reporting Services is corrupt in a way
that Windows Excel doesn't notice but Mac Excel does.

However, it could be something on your mac totally separate from Excel
itself that needs attention. MVP John McGimpsey has a page of things to
check. You can read it here:
http://www.mcgimpsey.com/macoffice/office/troubleshooting.html

Start at the top of the list and work your way down trying after each thing
to see whether or not that changed the situation. I would add one additional
item to John's list. After "check your settings" I would run Alsoft
DiskWarrior version 4.

My hunch is that Reporting Services is creating a badly constructed file in
the first place. But you won't know for sure until after you've tested the
things in John's list. Excel 2004 is not known to quit unexpectedly very
often.

-Jim Gordon
Mac MVP

I am using Office 2004 11.3.3 Reproting Services with Sp2

Hi,

What is the file format that Reporting Services creates? Is it xls or some
other format.

What version of Excel do you use? Have you installed all updates for your
copy of Excel?

Does the exact same file cause a crash on any other computer besides yours?

-Jim Gordon
Mac MVP


Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:

I have a report that I have to render in Excel, I have created the report
using Reporting Services. When I try to open the output Excel file, I get
the
Error message " Application Excel quit unexpectedly' and I am not able to
view the Excel file on MAC. Windows works just fine. The file size is only
about 100kb.

Any suggestions

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[MacUser]

I can also open the excel file( Report from Reporting Services) created on
the Mac machine on my PC using Office 2003. But it would'nt let me open it
in Office 2004 on the Mac

Hi,

My guess is that the file created by Reporting Services is corrupt in a way
that Windows Excel doesn't notice but Mac Excel does.

However, it could be something on your mac totally separate from Excel
itself that needs attention. MVP John McGimpsey has a page of things to
check. You can read it here:
http://www.mcgimpsey.com/macoffice/office/troubleshooting.html

Start at the top of the list and work your way down trying after each thing
to see whether or not that changed the situation. I would add one additional
item to John's list. After "check your settings" I would run Alsoft
DiskWarrior version 4.

My hunch is that Reporting Services is creating a badly constructed file in
the first place. But you won't know for sure until after you've tested the
things in John's list. Excel 2004 is not known to quit unexpectedly very
often.

-Jim Gordon
Mac MVP

I am using Office 2004 11.3.3 Reproting Services with Sp2

Hi,

What is the file format that Reporting Services creates? Is it xls or some
other format.

What version of Excel do you use? Have you installed all updates for your
copy of Excel?

Does the exact same file cause a crash on any other computer besides yours?

-Jim Gordon
Mac MVP


Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:

I have a report that I have to render in Excel, I have created the report
using Reporting Services. When I try to open the output Excel file, I get
the
Error message " Application Excel quit unexpectedly' and I am not able to
view the Excel file on MAC. Windows works just fine. The file size is only
about 100kb.

Any suggestions

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Jim Gordon MVP]

Hi,

This is good to know. If you want me to try one of the files please send it
to me (warmer-than-warm mail is hotmail). If you send a file please let me
know whether or not I can forward it to Microsoft.

Thanks.

-Jim Gordon
Mac MVP

I can also open the excel file( Report from Reporting Services) created on
the Mac machine on my PC using Office 2003. But it would'nt let me open it
in Office 2004 on the Mac

Hi,

My guess is that the file created by Reporting Services is corrupt in a way
that Windows Excel doesn't notice but Mac Excel does.

However, it could be something on your mac totally separate from Excel
itself that needs attention. MVP John McGimpsey has a page of things to
check. You can read it here:
http://www.mcgimpsey.com/macoffice/office/troubleshooting.html

Start at the top of the list and work your way down trying after each thing
to see whether or not that changed the situation. I would add one additional
item to John's list. After "check your settings" I would run Alsoft
DiskWarrior version 4.

My hunch is that Reporting Services is creating a badly constructed file in
the first place. But you won't know for sure until after you've tested the
things in John's list. Excel 2004 is not known to quit unexpectedly very
often.

-Jim Gordon
Mac MVP

I am using Office 2004 11.3.3 Reproting Services with Sp2

:

Hi,

What is the file format that Reporting Services creates? Is it xls or some
other format.

What version of Excel do you use? Have you installed all updates for your
copy of Excel?

Does the exact same file cause a crash on any other computer besides yours?

-Jim Gordon
Mac MVP


Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:

I have a report that I have to render in Excel, I have created the report
using Reporting Services. When I try to open the output Excel file, I get
the
Error message " Application Excel quit unexpectedly' and I am not able to
view the Excel file on MAC. Windows works just fine. The file size is only
about 100kb.

Any suggestions

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[MacUser]

Jim,
I sent an email to (e-mail address removed) but it bounced back.

We decided to export the file as tab-delimited csv file. This is the url i
am using.

http://servername/ReportServer?/old...mand=Render&rs:Format=CSV&rc:FieldDelimiter=

But when I export this report on the Mac machine, it creates the file as
Rpt_Name.csv.txt

Why does it append the .txt? I just want it as an .csv file. Is there a
way that I
can just output the file with the .csv extension?

Thanks in Advance

Hi,

This is good to know. If you want me to try one of the files please send it
to me (warmer-than-warm mail is hotmail). If you send a file please let me
know whether or not I can forward it to Microsoft.

Thanks.

-Jim Gordon
Mac MVP

I can also open the excel file( Report from Reporting Services) created on
the Mac machine on my PC using Office 2003. But it would'nt let me open it
in Office 2004 on the Mac

Hi,

My guess is that the file created by Reporting Services is corrupt in a way
that Windows Excel doesn't notice but Mac Excel does.

However, it could be something on your mac totally separate from Excel
itself that needs attention. MVP John McGimpsey has a page of things to
check. You can read it here:
http://www.mcgimpsey.com/macoffice/office/troubleshooting.html

Start at the top of the list and work your way down trying after each thing
to see whether or not that changed the situation. I would add one additional
item to John's list. After "check your settings" I would run Alsoft
DiskWarrior version 4.

My hunch is that Reporting Services is creating a badly constructed file in
the first place. But you won't know for sure until after you've tested the
things in John's list. Excel 2004 is not known to quit unexpectedly very
often.

-Jim Gordon
Mac MVP


Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:

I am using Office 2004 11.3.3 Reproting Services with Sp2

:

Hi,

What is the file format that Reporting Services creates? Is it xls or some
other format.

What version of Excel do you use? Have you installed all updates for your
copy of Excel?

Does the exact same file cause a crash on any other computer besides yours?

-Jim Gordon
Mac MVP


Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:

I have a report that I have to render in Excel, I have created the report
using Reporting Services. When I try to open the output Excel file, I get
the
Error message " Application Excel quit unexpectedly' and I am not able to
view the Excel file on MAC. Windows works just fine. The file size is only
about 100kb.

Any suggestions

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info



--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[steveandrobert]

Jim,
I sent an email to (e-mail address removed) but it bounced back.

We decided to export the file as tab-delimited csv file. This is the url i
am using.

http://servername/ReportServer?/oldername/Rpt_Name&argparam:isn...

But when I export this report on the Mac machine, it creates the file as
Rpt_Name.csv.txt

Why does it append the .txt? I just want it as an .csv file. Is there a
way that I
can just output the file with the .csv extension?

Thanks in Advance

Hi,

This is good to know. If you want me to try one of the files please send it
to me (warmer-than-warm mail is hotmail). If you send a file please let me
know whether or not I can forward it to Microsoft.

-Jim Gordon
Mac MVP

Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:

I can also open the excel file( Report fromReportingServices) created on
the Mac machine on my PC using Office 2003. But it would'nt let me open it
in Office 2004 on the Mac
:
Hi,
My guess is that the file created byReportingServicesis corrupt in a way
that Windows Excel doesn't notice but Mac Excel does.
However, it could be something on your mac totally separate from Excel
itself that needs attention. MVP John McGimpsey has a page of things to
check. You can read it here:
http://www.mcgimpsey.com/macoffice/office/troubleshooting.html
Start at the top of the list and work your way down trying after each thing
to see whether or not that changed the situation. I would add one additional
item to John's list. After "check your settings" I would run Alsoft
DiskWarrior version 4.
My hunch is thatReportingServicesis creating a badly constructed file in
the first place. But you won't know for sure until after you've tested the
things in John's list. Excel 2004 is not known to quit unexpectedly very
often.
-Jim Gordon
Mac MVP
Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:
I am using Office 2004 11.3.3 ReprotingServiceswith Sp2
:
Hi,
What is the file format thatReportingServicescreates? Is it xls or some
other format.
What version of Excel do you use? Have you installed all updates for your
copy of Excel?
Does the exact same file cause a crash on any other computer besides yours?
-Jim Gordon
Mac MVP
Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:
I have a report that I have to render in Excel, I have created the report
usingReportingServices. When I try to open the output Excel file, I get
the
Error message " Application Excel quit unexpectedly' and I am not able to
view the Excel file on MAC. Windows works just fine. The file size is only
about 100kb.
Any suggestions
--
Jim Gordon
Mac MVP
MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/
--
Jim Gordon
Mac MVP
MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/

MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/

Microsoft has released a "hot fix" for Reporting Services to deal with
this issue. See: http://support.microsoft.com/kb/918529

 

[Jim Gordon MVP]

Hi Steve and Robert,

I'm glad you were able to help out with this one. Thank you!

To be clear, the problem is with Reporting Services, not Excel.

"Microsoft has released a "hot fix" for Reporting Services to deal with
this issue. See: http://support.microsoft.com/kb/918529"

-Jim Gordon
Mac MVP

Jim,
I sent an email to (e-mail address removed) but it bounced back.

We decided to export the file as tab-delimited csv file. This is the url i
am using.

http://servername/ReportServer?/oldername/Rpt_Name&argparam:isn...

But when I export this report on the Mac machine, it creates the file as
Rpt_Name.csv.txt

Why does it append the .txt? I just want it as an .csv file. Is there a
way that I
can just output the file with the .csv extension?

Thanks in Advance

Hi,

This is good to know. If you want me to try one of the files please send it
to me (warmer-than-warm mail is hotmail). If you send a file please let me
know whether or not I can forward it to Microsoft.

-Jim Gordon
Mac MVP

Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:

I can also open the excel file( Report fromReportingServices) created on
the Mac machine on my PC using Office 2003. But it would'nt let me open
it
in Office 2004 on the Mac

:

My guess is that the file created byReportingServicesis corrupt in a way
that Windows Excel doesn't notice but Mac Excel does.

However, it could be something on your mac totally separate from Excel
itself that needs attention. MVP John McGimpsey has a page of things to
check. You can read it here:
http://www.mcgimpsey.com/macoffice/office/troubleshooting.html

Start at the top of the list and work your way down trying after each
thing
to see whether or not that changed the situation. I would add one
additional
item to John's list. After "check your settings" I would run Alsoft
DiskWarrior version 4.

My hunch is thatReportingServicesis creating a badly constructed file in
the first place. But you won't know for sure until after you've tested the
things in John's list. Excel 2004 is not known to quit unexpectedly very
often.

-Jim Gordon
Mac MVP

Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:

I am using Office 2004 11.3.3 ReprotingServiceswith Sp2

:

What is the file format thatReportingServicescreates? Is it xls or some
other format.

What version of Excel do you use? Have you installed all updates for
your
copy of Excel?

Does the exact same file cause a crash on any other computer besides
yours?

-Jim Gordon
Mac MVP

Quoting from "MacUser" <[email protected]>, in article
(e-mail address removed), on [DATE:

I have a report that I have to render in Excel, I have created the
report
usingReportingServices. When I try to open the output Excel file, I get
the
Error message " Application Excel quit unexpectedly' and I am not able
to
view the Excel file on MAC. Windows works just fine. The file size is
only
about 100kb.

Any suggestions

MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/

MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/

MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/

Microsoft has released a "hot fix" for Reporting Services to deal with
this issue. See: http://support.microsoft.com/kb/918529

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info