bothers me a lot when open a book, and say me ....

[jamiguel77]

Hi friends...

bothers me a lot when i open a excel book, for view and when close....

display me the window asking me if want save or not...

Strange, if i dont do any change.... i am sure..


how to fix it?


i want ask me if want save, only if i make changes....

thanks

 

[Joe4]

Strange, I don't get that behavior.
If I do not change anything and try to close it, it does not prompt me asking me if I want to save the file. It just closes it.
Are you sure that the code does not have any VBA running in the background that code be making updates?
Does it contain any VBA code at all?

 

[Fluff]

Along with what Joe4 has said,
Are you opening the file in compatibility mode, or do you have formulas referencing other workbooks?

 

[jamiguel77]

not references to other books...

no vba code....

how to open file with compatibility mode?

Thanks..

 

[Fluff]

Compatability mode is when you open an xls file in xl2007 or newer.

 

[RoryA]

It sounds to me like you have volatile formulas in the workbook, or you’re opening a workbook that was previously calculated in an earlier version of Excel.

 

[Joe4]

As Rory replies suggests, if that is the issue, that it was created in an earlier version of Excel, try saving it in the recent version with the proper extension (probably "xlsx").

 

[RoryA]

You don’t actually have to change the format, just save it in the newer version of Excel.

 

[Joe4]

You don’t actually have to change the format, just save it in the newer version of Excel.

Did not know that. Thanks for clarifying!

 

[jamiguel77]

ok, i try saving in NEW format.....

and check the actual extension.


thanks to all