Excel prompting to save changes when only opened to print

[Bennie47250]

Using Excel 2003

We have a process that will automatically open an excel spreadsheet and print it and then close the sheet. Occasionally when the program is closing the sheet, Excel is prompting to save changes even thought no changes have been made. I suspect it has to do with formulas that are recalculating when the sheet is opened.

Any thoughts as to why Excel would be prompting to save and how to disable this feature?

We have about 500 workbooks it is processing and about 75% of them are getting the prompt.

Thanks
Bennie

 

[AnotherHiggins]

Common causes:
[tab]-formulas that reference other workbooks
[tab]-Named Ranges that refer to a sheet that no longer exists
[tab]-Links to other workbooks
[tab]-Volatile functions (Now, Today)

how are you closing the files? If you are using VBA, then you could use something like this to suppress the message:

ActiveWorkbook.Close savechanges:=False

But VBA questions should be posted in forum707.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[cheerio]

Another cause of this: if the Excel workbook was produced in an earlier version of Excel then Excel 2003 will always recalculate and mark the book as unsaved.

 

[Bennie47250]

Thanks for the tips. The program that is processing the sheets is provided by our document imaging provider so the chances of rewriting the program are slim to none.

Does anyone know of a viewer program that would open the document to allow for the printing but since it is a view only, not prompt for changes?

 

[Bennie47250]

Of course Microsoft has a viewer. I will give it a try to see how it reacts to these sheets.