Document not saved

[jrlgel]

Hi I am having a problem saving a document that contains Macro. I can run the
macro that imports my data from other sheets but when it comes time to save
the document I will see excel attempt to save the file but then it errors
with "document not saved". If I remove the macro then of course it does save.
I believe it is something in the registry that tells excel it cannot save a
sheet with macro but I do not know where. I am a novice at writing the code
and someone else wrote it before I took of the position so I am hoping
someone can help me out. I do not believe it is something in the code because
I can take the document to another computer and it saves fine. Any help would
be appreciated. Thank you for your advice.

 

[Sam Wilson]

"Document Not Saved" is usually bad news - I get it when my users have
temporarily lost network connection after opening a file. Even though the
connection is restored before they try and save there's no way around, with
Save As etc. They end up having to copy the data into a new workbook to save
that.

I'm not aware of any registry settings.

Sam