Save changes?
Every time i open an Excel-file saved in an earlier version I get the same
question when closing the file: Microsoft Office Excel recalculates the formulas when files, saved in earlier versions of Excel are opened. Do you want to save..... Is there any way to close this function so that the dialog box does not appear every time? |
Not really, but why do you respond to it with a No everytime ? Save (or
select Yes) once, and it is not saved in an earlier version anymore. HTH. Best wishes Harald "Lena_excel" skrev i melding ... Every time i open an Excel-file saved in an earlier version I get the same question when closing the file: Microsoft Office Excel recalculates the formulas when files, saved in earlier versions of Excel are opened. Do you want to save..... Is there any way to close this function so that the dialog box does not appear every time? |
That is a way to "get around" the problem but does not solve it, since all
files get new dates and I am quite depending on dates to keep track on files. But if it is the only way, I have to live with that. Lena "Harald Staff" skrev: Not really, but why do you respond to it with a No everytime ? Save (or select Yes) once, and it is not saved in an earlier version anymore. HTH. Best wishes Harald "Lena_excel" skrev i melding ... Every time i open an Excel-file saved in an earlier version I get the same question when closing the file: Microsoft Office Excel recalculates the formulas when files, saved in earlier versions of Excel are opened. Do you want to save..... Is there any way to close this function so that the dialog box does not appear every time? |
Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl Maybe it'll work ok for you. Lena_excel wrote: Every time i open an Excel-file saved in an earlier version I get the same question when closing the file: Microsoft Office Excel recalculates the formulas when files, saved in earlier versions of Excel are opened. Do you want to save..... Is there any way to close this function so that the dialog box does not appear every time? -- Dave Peterson |
Perfect, this solves my problems, thanks
Lena "Dave Peterson" skrev: Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl Maybe it'll work ok for you. Lena_excel wrote: Every time i open an Excel-file saved in an earlier version I get the same question when closing the file: Microsoft Office Excel recalculates the formulas when files, saved in earlier versions of Excel are opened. Do you want to save..... Is there any way to close this function so that the dialog box does not appear every time? -- Dave Peterson |
"Dave Peterson" skrev i melding
... Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl You live and you learn. Thanks Dave. Is there a list of "not yet generated registry entries" like this anywhere ? Best wishes Harald |
I wait for Jim Rech to post and then keep a copy. And this question has come
up a few times since xl2003 came out so I knew I had saved this response. I'm not sure how Jim knows this stuff, but I like to lurk behind his postings. (I don't have a list.) Harald Staff wrote: "Dave Peterson" skrev i melding ... Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl You live and you learn. Thanks Dave. Is there a list of "not yet generated registry entries" like this anywhere ? Best wishes Harald -- Dave Peterson |
Save changes?
I save a file that i was working over an existing file. How can i recuperate
de old file? It was so inmportant!! "Lena_excel" wrote: Every time i open an Excel-file saved in an earlier version I get the same question when closing the file: Microsoft Office Excel recalculates the formulas when files, saved in earlier versions of Excel are opened. Do you want to save..... Is there any way to close this function so that the dialog box does not appear every time? |
Save changes?
You can go back to the backup that you kept. If it was so important, you
will have the used the option for "always create backup" under "save as". [If not, you will do next time, I'm sure.] -- David Biddulph "max" wrote in message ... I save a file that i was working over an existing file. How can i recuperate de old file? It was so inmportant!! "Lena_excel" wrote: Every time i open an Excel-file saved in an earlier version I get the same question when closing the file: Microsoft Office Excel recalculates the formulas when files, saved in earlier versions of Excel are opened. Do you want to save..... Is there any way to close this function so that the dialog box does not appear every time? |
All times are GMT +1. The time now is 10:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com