Double saving?

[GARY]

In Excel 2007, when I save a spreadsheet, the "Status bar" displays
the word "Saving" plus the file-name, "Press Esc to Cancel" and the
progress bar.

Then, a "Saving" box is displayed in the middle of the spreadsheet.
This box contains the phrase "Saving As:" plus the drive-ID, the
folder-name, the file-name and a progress bar.

Does this mean the spreadsheet is being saved twice? If "Yes", how I
can I change Excel to save it only once?

 

[GS]

GARY formulated on Friday :

In Excel 2007, when I save a spreadsheet, the "Status bar" displays
the word "Saving" plus the file-name, "Press Esc to Cancel" and the
progress bar.

Then, a "Saving" box is displayed in the middle of the spreadsheet.
This box contains the phrase "Saving As:" plus the drive-ID, the
folder-name, the file-name and a progress bar.

Does this mean the spreadsheet is being saved twice? If "Yes", how I
can I change Excel to save it only once?

The 'SaveAs' dialog only appears when you are saving a new wkb that has
never been saved. This could be a wkb that was created using 'New' OR
one that was created from a template.

 

[Clif McIrvin]

GARY formulated on Friday :

The 'SaveAs' dialog only appears when you are saving a new wkb that
has never been saved. This could be a wkb that was created using 'New'
OR one that was created from a template.

I don't believe OP is referring to the 'SaveAs' dialog. In xl2010, I
see similiar behavior when saving to a format other than .xlsx and/or to
a network share. I've never bothered to try and figure out what or why,
or even to be terribly particualr about noticing precisely when I do or
don't see the behavior.

 

[GS]

Clif McIrvin pretended :

I don't believe OP is referring to the 'SaveAs' dialog. In xl2010, I see
similiar behavior when saving to a format other than .xlsx and/or to a
network share. I've never bothered to try and figure out what or why, or even
to be terribly particualr about noticing precisely when I do or don't see
the behavior.

The OP is using 2007. Can't say I've seen this behavior there when
saving previously saved files. I have, but not installed yet, 2010 and
so I can't speak to what you mention here.

Also, a dialog appears when you try saving earlier version files. I've
never done that and so can't say if the SaveAs dialog appears in this
case.

 

[Dave Peterson]

I'm guessing that you have some sort of event macro that's running.

Do you see this behavior with just a single workbook?

If yes, then I'd bet you have a workbook_beforesave event that's firing.

Try opening excel in safe mode to disable all macros.

Close excel
windows start button|Run
excel /safe

Open your workbook and try saving it.

If you don't see the problem, then go back to the developer to see why he or she
is doing this. If you're the developer, look in the ThisWorkbook module in the
VBE for this workbook.



If it happens with all workbooks, you could have an addin that's "helping".

Starting in safe mode would stop this behavior, too. But the solution may be
just to uninstall the addin.

 

[Clif McIrvin]

Hmm. I ran some tests on one of my workbooks (in xl2010) that does have
event code: a worksheet.Activate event on one of the sheets, and a
workbook.open event.

Simplified report of my observations:

Standard conditions (two addins, and Personal.xlsb loaded), saving as
..xlsb on network share: status bar "Saving" progress followed by "Saving
As" progress dialog.
- Save same workbook, same conditions, to local hard drive, no Saving As
dialog.

Unload all addins and the personal macro workbook, strip all macro code
from the workbook, re-compile, save as .xlsx.
- saving to network share, the "Saving As" dialog still appears some
time after the status bar "Saving" progress completes, though it's
merely a flicker this time.
- save to local hard drive, no "Saving As" dialog.

I did not load Excel in safe mode.

Not complaining, simply reporting observations.

Clif

 

[Dave Peterson]

I haven't installed xl2010, but the OP was writing about xl2007.

And my point wasn't about any event macro -- it was specifically about the
workbook_beforesave event.

 

[Clif McIrvin]

I haven't installed xl2010, but the OP was writing about xl2007.

And my point wasn't about any event macro -- it was specifically about
the workbook_beforesave event.

Yes, I realized the OP reference to xl2007 ... and jumped in simply
because I recognized in OP's description behavior that I was seeing in
xl2010. (I rarely know whether the information I'm sharing is common
knowledge or not ... and have seen too many times when time could have
been saved had I spoken up sooner but didn't from the mistaken
assumption that others had seen what I was seeing.)

From your response, I saw the possibility of relevance to my situation,
so did a bit of testing --- and merely reported my observations ---
again, not knowing how valuable my contribution is, but knowing that
these threads are available for future search. Who knows whether my
simple contribution will prove useful to someone, sometime? It seemed
worthwhile to me to jump in, at any rate!

I keyed in on your reference to event code ... and have in fact
experienced some (what seems to me to be) odd behavior from a workbook
that uses Application.OnKey ... so it seemed plausible to generalize
your point about the workbook_beforesave event and see if it made any
difference for me.

Clif

 

[GARY]

Aha! The "double saving" occurs only when I'm running Excel within
the Citrix Presentation Server Client. When I'm running Excel by
itself, the "save" happens only once.