Excel Question

S

Sunny

Registered User
Messages
4,571
Hope someone can help me with this.

I have a workbook with about 15 worksheets that update daily when I open the workbook to take into account the new date and other updated info.

The problem is that I need to save the updated file each day so I want a copy that doesn't update every day when I open the file.

Is there anyway to do this other than copying and pasting each worksheet into a new workbook every day?
 
"Is there anyway to do this other than copying and pasting each worksheet into a new workbook every day? "

Before you open the file, go to the folder using Windows Explorer, copy and paste the file, rename the copy to todays date and then go and open your original.

There are loads of little applications for free on the internet which will backup a file incremently every day for you in a folder (do the copy and pasting automatically). It would run in the background on your pc. You would then have a dated copy of your original file each day
 
You must log in or register to reply here.
Back
Top