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" <Lena_excel@discussions.microsoft.com> skrev i melding
news:0DC74CAB-0136-4054-81D7-034E6AFC408F@microsoft.com...
> 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" <Lena_excel@discussions.microsoft.com> skrev i melding
> news:0DC74CAB-0136-4054-81D7-034E6AFC408F@microsoft.com...
> > 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...TNGP11.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...TNGP11.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" <ec35720@netscapeXSPAM.com> skrev i melding
news:41F6D7F5.D56D4792@netscapeXSPAM.com...
> Jim Rech posted a registry tweak:
>
http://groups.google.com/groups?thre...TNGP11.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" <ec35720@netscapeXSPAM.com> skrev i melding
> news:41F6D7F5.D56D4792@netscapeXSPAM.com...
> > Jim Rech posted a registry tweak:
> >
> http://groups.google.com/groups?thre...TNGP11.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