Excel keeps asking to save unmodified files, very anoying after a while.
Any Idea
SP3 installed
Excel keeps asking to save unmodified files, very anoying after a while.
Any Idea
SP3 installed
There are worksheet functions that are volatile. They recalculate whenever
excel recalculates the workbook.
Do you have functions like:
AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()
And newer versions of excel like to recalculate older workbooks when they're
opened. Then xl knows that the file is changed and prompts you accordingly.
Alan wrote:
>
> Excel keeps asking to save unmodified files, very anoying after a while.
>
> Any Idea
>
> SP3 installed
--
Dave Peterson
No I don't have any of those functions.
I fact I just created a new sheet with just some text in one cell
Saved as book1
Reopened, did nothing and got the save doument prompt when I closed it??
Thanks for your reply
Alan
"Dave Peterson" wrote:
> There are worksheet functions that are volatile. They recalculate whenever
> excel recalculates the workbook.
>
> Do you have functions like:
>
> AREAS()
> INDEX()
> OFFSET()
> CELL()
> INDIRECT()
> ROWS()
> COLUMNS()
> NOW()
> TODAY()
> RAND()
>
> And newer versions of excel like to recalculate older workbooks when they're
> opened. Then xl knows that the file is changed and prompts you accordingly.
>
>
> Alan wrote:
> >
> > Excel keeps asking to save unmodified files, very anoying after a while.
> >
> > Any Idea
> >
> > SP3 installed
>
> --
>
> Dave Peterson
>
Do you get the same problem if you open excel in Safe mode:
Close excel
windows start button|Run
excel /safe
file|open your book.xls
File|close (no changes)
If you get prompted, I don't have a guess. If no, then maybe you have a macro
that's helping out.
Chip Pearson has a page that can help you find that helpful macro:
http://www.cpearson.com/excel/StartupErrors.htm
========
There have been a few problems associated with Google's Desktop Search. Do you
have that installed on your pc?
If yes, maybe disabling that COM Add-In will help.
One way to turn it off:
In excel,
Tools|customize|Commands tab|Tools Category
Scroll down the commands listbox and
Drag "COM Add-ins..." to under Tools|Addins
(It seems to make sense there.)
Then close up that dialog.
Back to Tools|COM Add-ins...
Turn off the google desktop search addin.
(You could use a registry tweak, too. But I think that this is safer/easier.)
===
This google addin shows up in other Office applications, too. You may want to
look at disabling it in those other office programs, too (well, if you
experience problems).
Alan wrote:
>
> No I don't have any of those functions.
>
> I fact I just created a new sheet with just some text in one cell
> Saved as book1
> Reopened, did nothing and got the save doument prompt when I closed it??
>
> Thanks for your reply
>
> Alan
>
> "Dave Peterson" wrote:
>
> > There are worksheet functions that are volatile. They recalculate whenever
> > excel recalculates the workbook.
> >
> > Do you have functions like:
> >
> > AREAS()
> > INDEX()
> > OFFSET()
> > CELL()
> > INDIRECT()
> > ROWS()
> > COLUMNS()
> > NOW()
> > TODAY()
> > RAND()
> >
> > And newer versions of excel like to recalculate older workbooks when they're
> > opened. Then xl knows that the file is changed and prompts you accordingly.
> >
> >
> > Alan wrote:
> > >
> > > Excel keeps asking to save unmodified files, very anoying after a while.
> > >
> > > Any Idea
> > >
> > > SP3 installed
> >
> > --
> >
> > Dave Peterson
> >
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks