File.Save does not really save the current (or complete) status of the excel workbook (XL2000)

  • Thread starter Thread starter Gerhard Braendle
  • Start date Start date
G

Gerhard Braendle

I am facing a funny (???) phenomenon when I (or others) save a large
(approx. 8MB) Excel 2000
workbook. Especially when I make changes to a dialog, then save the workbook
and
open it again, these changes are not (or only partially ???) effective...
But also simple changes to one or more of the Worksheets (approx. 20 large
sheets) will
not be saved consistently.
Any help ?
- Gerhard
 
I've never seen excel do this with any size workbook.

Are you sure you're opening the file that you just saved? Maybe your saved
version is in a different folder.

Try putting this formula in a worsheet cell.
=CELL("filename",A1)
Note the location.

Now, save, close and reopen. Did you get the same info?
 
I am absolutely sure to open the very same file.
Some more details: When I e.g. make some changes to an existing dialog, lets
say
I am moving a textbox to a different location on the very same dialog, then
save and close
the document and open it again, the modification to the textbox has not been
saved.
Note: The Workbook has quite a few Worksheets (approx. 15) and 4 of them
have
like 5000 rows with 10 to 40 columns.

Possibly the problem is related to (known) problems of Excel (better MS
Office) with
temporary files being created (usually) in the %TEMP% folder.
I have personally seen some VBA macros failing with a crowded %TEMP% folder
and
being functional again after having cleaned that directory.
From there it seems to be possible that the %TEMP% problem could also cause
loss of data in certain situations.

- Gerhard
 
I've seen excel slow down when the temp folder's files get too many. I don't
recall seeing any failing macros based on this, though.

And I don't use dialog sheets at all.

But that workbook size (15 worksheets, 5000 rows by 10-40 columns) doesn't sound
too large to me--just based on those stats.

Maybe you could try opening excel in safe mode to see if anything happens:

Close excel
windows start button|Run
excel /safe
then file|open your workbook

Did it move around when you opened it?
Make some changes and save it.
Reopen (while still in safe mode) and check it out.

===
And I'm not trying to be irritating--it's just my nature--did you actually
verify that you're opening the same file?

(I've heard that lots of gunshot wounds are caused by unloaded guns. <vbg>)
 
Back
Top