Save problem

[Guest]

Hi,

For the past couple of day I am experiencing this strange problem when I try
to save an excel document. If any documents has more than one worksheet when
I save excel will flashes through all the worksheet tabs and then it saves
it! It takes a few seconds but I am just concerned what is happening.

Any insights?

Thanks in advance-

Nikki

 

[Bob Flanagan]

Sounds like you have a macro running when you close the workbook. Are there
macros in it? Did you install a new add-in on your system?

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Gord Dibben]

Do you have some BeforeSave event code in Thisworkbook module that does
something to each sheet upon saving?


Gord Dibben MS Excel MVP

 

[Guest]

no. even a brand new workbook does the same thing. not excatly sure why.

thanks-
Nikki

 

[Guest]

Hi Bob,

Yes I have upgraded Hyperion Essbase but so has my co-workers and none of
them has this problem. I have no idea what could be the probelm. this happens
even when i save a brand new workbook that has nothing in it. so macro can
not be the probelm since there are none in a new workbook. any ideas?

thanks for you help-