"Document not saved" and very large temporary excel files...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cs - 23 Oct 2007 18:00 GMT

When attempting to save our addin it times out after a couple of minutes and
displays a "Document Not Saved" dialog

While saving, the temp save file that Excel creates grows to about 2gig
before excel "times out".

This usually starts happening after a bit of coding...

We are using Excel 2003. And our addin contains quite a bit of VBA (say
about 50k lines). We usually run excel sessions with many 3rd Party addins of
a financial nature (Reuters/Bloomberg etc).

Thanks for any help.

Reply to this Message

cs - 23 Oct 2007 18:06 GMT

...the xls file is about 10 mb when it manages to save...

Reply to this Message

Jim Cone - 23 Oct 2007 18:21 GMT

An Excel add-in, prior to xl2007, has a .xla extension not .xls.
The rule of thumb seems to be to keep workbook modules under 64K in size.
If you have 50,000 code lines in only one or two modules then your problems
may come from the large module size.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"cs"
wrote in message
When attempting to save our addin it times out after a couple of minutes and
displays a "Document Not Saved" dialog

While saving, the temp save file that Excel creates grows to about 2gig
before excel "times out".

This usually starts happening after a bit of coding...

We are using Excel 2003. And our addin contains quite a bit of VBA (say
about 50k lines). We usually run excel sessions with many 3rd Party addins of
a financial nature (Reuters/Bloomberg etc).

Thanks for any help.

Reply to this Message

Rate this thread: