![]() |
Save problem
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 |
Save problem
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 "Nikki" wrote in message ... 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 |
Save problem
Do you have some BeforeSave event code in Thisworkbook module that does
something to each sheet upon saving? Gord Dibben MS Excel MVP On Thu, 28 Jun 2007 16:32:01 -0700, Nikki wrote: 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 |
Save problem
no. even a brand new workbook does the same thing. not excatly sure why.
thanks- :) Nikki "Gord Dibben" wrote: Do you have some BeforeSave event code in Thisworkbook module that does something to each sheet upon saving? Gord Dibben MS Excel MVP On Thu, 28 Jun 2007 16:32:01 -0700, Nikki wrote: 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 |
Save problem
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- "Bob Flanagan" wrote: 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 "Nikki" wrote in message ... 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 |
All times are GMT +1. The time now is 07:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com