Visio crashes when exporting Org Chart to Excel

[tonyfleming1]

Hi

I have got Visio 2007 and have developed an Organisation Chart using
the standard template.
Whenever I try to export it to Excel, Visio crashes.

I *have* been to the Micosoft site and installed any updates/Service
Packs my laptop needed, but I'm not getting anywhere with this.


Can anyone help?

THanks
Tony

 

[Aaron Rykhus [MSFT]]

Try creating a new org chart and see if you get the crash when exporting
that to Excel. That will tell you if it's application-wide or just file
specific. If you get the crash in a new org chart then try starting Visio
in application safe mode by holding down the Ctrl key and starting Visio
until you get prompted Yes/No. If you still get the crash try repairing
Visio.

Also, check in the Event Viewer's Application Log in Control Panel >
Administrative Tools for any sources named Application Error or Office 12.
There should be the crash details (something with Visio.exe). If you could
post a reply with the crash details and the version/service pack of Excel
that would be helpful too.


Best Regards,

Aaron Rykhus, MCP, MCDST
Online Support Engineer
Microsoft Corporation

 

[tonyfleming1]

Try creating a new org chart and see if you get the crash when exporting
that to Excel. That will tell you if it's application-wide or just file
specific. If you get the crash in a new org chart then try starting Visio
in application safe mode by holding down the Ctrl key and starting Visio
until you get prompted Yes/No. If you still get the crash try repairing
Visio.

Also, check in the Event Viewer's Application Log in Control Panel >
Administrative Tools for any sources named Application Error or Office 12.
There should be the crash details (something with Visio.exe). If you could
post a reply with the crash details and the version/service pack of Excel
that would be helpful too.

Best Regards,

Aaron Rykhus, MCP, MCDST
Online Support Engineer
Microsoft Corporation

Hi Aaron

Thanks for your post.

I have tried creating new org charts both in safe and "normal" mode
and I still get the same problem.
I have been into the event viewer. When Visio crashed, the last event
of type "Error" was as follows:

Faulting application visio.exe, version 12.0.6211.1000, stamp
46d4ae1d, faulting module ntdll.dll, version 5.1.2600.2180, stamp
411096b4, debug? 0, fault address 0x000431a0.


The associated event of type "Information" was:

Bucket 593640963, bucket table 1, faulting application visio.exe,
version 12.0.6211.1000, stamp 46d4ae1d, faulting module ntdll.dll,
version 5.1.2600.2180, stamp 411096b4, debug? 0, fault address
0x000431a0.


I have Excel 2003 SP3 and Visio 2007 SP1

Hope that helps!
Tony

 

[Aaron Rykhus [MSFT]]

See if it works on a different user. You can run Visio as a different user,
hold the shift key down, right-click on the Visio icon and choose Run As,
login with the other user's credentials. If you still get the crash, try
repairing Office 2003.


Best Regards,

Aaron Rykhus, MCP, MCDST
Online Support Engineer
Microsoft Corporation

 

[tonyfleming1]

See if it works on a different user. You can run Visio as a different user,
hold the shift key down, right-click on the Visio icon and choose Run As,
login with the other user's credentials. If you still get the crash, try
repairing Office 2003.

Best Regards,

Aaron Rykhus, MCP, MCDST
Online Support Engineer
Microsoft Corporation

Hi and sorry for the delay. I would not have been able to run it as a
different user as it is my own laptop and is not used by others.
However, it looks like I have found out what the problem is! Here
goes:

Set up an organisation chart in Visio 2007

Select Organisation Chart > Export Organisation Data

When the window pops up requesting you to specify a location and name
for the file you're about to create, ensure that it will save the data
as an excel spreadsheet
Next type the name of the file you want to create. Here's the key bit
- ensure that the name you type ends in ".xls"!! Don't rely on Visio
to automatically append the suffix for you, even if you've specified
the filetype in advance.

If you type in the filename without the suffix - just as you would
anywhere else - it crashes with the error I described earlier. This
seems weird because, as I said I would rely on any MS package to cope
without needing to apply a suffix.

Hope that helps. Any chance that this will get fixed?

Tony

 

[Mark Nelson [MS]]

This seems to be machine or file specific. The steps you describe work on
the machines I can test with. Another possibility is that there is another
action in the repro steps that we aren't capturing.

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Aaron Rykhus [MSFT]]

I don't get this problem on my Vista box with Office 2007 SP1 and Visio Pro
2007 SP1, you shouldn't need to put a file extension after the filename, it
will add that for you. If it's not adding the ext. I'd run a repair on
Visio and Office and make sure you're on the latest service packs for both.


Best Regards,

Aaron Rykhus, MCP, MCDST
Online Support Engineer
Microsoft Corporation

 

[tonyfleming1]

This seems to be machine or file specific.  The steps you describe work on
the machines I can test with.  Another possibility is that there is another
action in the repro steps that we aren't capturing.

--
Mark Nelson
Office Graphics -Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights..













- Show quoted text -

Hi

I put details of my problem on another Visio board and got the
following reply:

Hi Tony -


This issue has been logged, but it was found to late to include a fix in
SP1, so we hope to address it in a future service pack. There is a work
around, however, that you can try. When you are creating the Filename to
export your data, specify the extension manually (rather than permit the
dialog to automatically add the extension). This seems to force the
correct export filter, and should allow you to create the export files that
you need.


I'm sorry this problem has impacted you, and will suggest a public article
to help make the work around easier to find.


Barb Way
Product Support - Visio
Microsoft Corporation

There was also a reference from Barb about installing the file format
compatability pack from MS as a solution, although I haven't done it
yet - I'm just so grateful that I have overcome the problem!!!

Thanks
Tony