File is saved on opening

  • Thread starter Thread starter Roadie
  • Start date Start date
R

Roadie

Hi all,

I have an Excelfile that, when I open it, immediately saves itself.
have no idea why it does that and since it is a file of nearly 50 Mb,
really hate to spend a lot of time to watch Excel save that 50 Mb'
every time I open the file. I created the file, but after that it'
been used by others.
The AutoSave is not installed. This original 50Mb file contains severa
macros, none of them have any AutoOpen statements, but just to be sure
I copied the file and stripped it completely.

I now have a file that contains no macro's and just 1 empty sheet. Th
size is now 17 kb, but it still saves on opening (a lot faster than th
50 Mb :) ). I can't think of any reason why Excel would do that. An
it's just those two files (the original and the copy), because when
open another file, nothing happens.
Has anyone a clue as to what is happening here? Is there any optio
that's checked and should be unchecked?

Regards,

Anne
 
Do you have a Workbook_Open() event macro in the ThisWorkbook code
module?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top