View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

The blank workbook might mean that you have a book.xlt template file that was
created in a different (pre xl2k) version of excel.

Open that template workbook and save it so that xl2k will see it as the same
version that you are running.

And for the other workbooks...

Do you have any of these volatile functions in your workbook?

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()

These evaluate with each calculation. And cause excel to think your workbook
has changed.

And excel likes to recalculate workbooks created in earlier versions. Is this
the case in your situation?



MXH wrote:

Hi,

Excel 2000 - when I open a workbook then close, I get prompted to Save my
changes. I also get propmted when closing a blank workbook that has just been
created.

Any ideas please?

Thanks


--

Dave Peterson