Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel 2003 hangs on save after creating pivot table

I have isolated this problem to something having to do with the workbook
connections. Here is what I know:

When I create a pivot table (using NotesSQL ODBC driver) in a workbook in
Excel 2003, I cannot save the workbook - Excel starts to save, shows the save
progress on the status bar, then just hangs.

When I do the same thing in Excel 2007, I have no problem.

If I create the pivot table in 2007, then open and try to save in 2003, it
hangs.

If I create the pivot in 2007, THEN DELETE ALL OF THE WORKBOOK.CONNECTIONS,
save it, I can open and save in 2003.

You would think that all I need to do is delete all of the workbook
connections in 2003, and everything will be right with the world. One problem
- there is no workbook connections collection in 2003!!! Somehow the
relationship between pivot tables and connections is different between 2003
and 2007.

My ultimate goal is to be able to create and save a pivot table in 2003.

Any suggestions?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
'Save As' hangs Excel XP 2002 SP3 Slim Excel Discussion (Misc queries) 0 April 26th 10 07:42 PM
Excel hangs on Save As Zarch Excel Programming 6 December 6th 07 06:04 PM
creating a table on microsoft excel 2003 clh New Users to Excel 2 July 31st 07 02:38 AM
Shared pivot table hangs J Owen Excel Discussion (Misc queries) 0 January 11th 07 09:19 PM
EXCEL hangs on PIVOT table!! scardy Excel Programming 0 April 18th 06 02:46 PM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"