ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel automatically creates a backup speadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/73772-excel-automatically-creates-backup-speadsheet.html)

RLaurel

Excel automatically creates a backup speadsheet
 
This only happens with one specific spreadsheet.

In the file structure I delete all documents named "Backup of X". Then I
edit spreadsheet "X". Upon closure of the Excel session, I see in the file
structure again, "Backup of X" with the time and date stamp of the previous
session.

I have looked In Excel Tools - Options - General tab - Default file location
and Excel Tools - Options - General tab - Save tab - Autorecovery file
location. Neither are pointed to a network environment where this is
happening.

I suspect it is a either a Macro or Visual Basic script executing on this
one spreadsheet. I have looked at the Macros and Visual Basic scripts I can
see and I don't see anything I would consider suspect.

Does anyone here know?

Biff

Excel automatically creates a backup speadsheet
 
Hi!

Look in:

FileSave asToolsGeneral optionsAlways create backup

Biff

"RLaurel" wrote in message
...
This only happens with one specific spreadsheet.

In the file structure I delete all documents named "Backup of X". Then I
edit spreadsheet "X". Upon closure of the Excel session, I see in the
file
structure again, "Backup of X" with the time and date stamp of the
previous
session.

I have looked In Excel Tools - Options - General tab - Default file
location
and Excel Tools - Options - General tab - Save tab - Autorecovery file
location. Neither are pointed to a network environment where this is
happening.

I suspect it is a either a Macro or Visual Basic script executing on this
one spreadsheet. I have looked at the Macros and Visual Basic scripts I
can
see and I don't see anything I would consider suspect.

Does anyone here know?





All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com