We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Excel File Location
![[Deleted User]](https://us-noi.v-cdn.net/6031891/uploads/defaultavatar/nFA7H6UNOO0N5.jpg)
[Deleted User]
Posts: 0 Newbie
in Techie Stuff
Is it possible to set the Autorecover file location separately for each file? As far as I can see, if I change the location it applies to all Excel files until I change it back again.
I'd like to start keeping my accounts on Excel, but I don't want the Autorecover saving data on the HDD rather than on the USB stick where the main file will be.
It's far too much aggro to remember to change the location every time I open and close my accounts file, but I don't want data left on the HDD either, in case the computer has to go for repair.
I'd like to start keeping my accounts on Excel, but I don't want the Autorecover saving data on the HDD rather than on the USB stick where the main file will be.
It's far too much aggro to remember to change the location every time I open and close my accounts file, but I don't want data left on the HDD either, in case the computer has to go for repair.
0
Comments
-
A hard drive is much, much more reliable than a USB stick. Operating from just a USB drive is a BAD idea and you will lose your files.
Also which is more likely to go missing, a USB stick or a laptop?
Dave0 -
USB memory is not a reliable form of long-term data storage. Also, when (not if, when) you delete files by accident, they don't go to the Recycle Bin and are irrecoverable.
For transporting copies of files, USB sticks are fine.
For long-term portable and external data storage, I use an old 2.5" laptop hard disc in an external USB enclosure. These work just like any other hard drive, are relatively compact and powered through the USB interface. Just don't drop it, though.If you fold it in half, will an Audi A4 fit in a Citroen C5?
0 -
Is it possible to set the Autorecover file location separately for each file? As far as I can see, if I change the location it applies to all Excel files until I change it back again.
I'd like to start keeping my accounts on Excel, but I don't want the Autorecover saving data on the HDD rather than on the USB stick where the main file will be.
It's far too much aggro to remember to change the location every time I open and close my accounts file, but I don't want data left on the HDD either, in case the computer has to go for repair.
The autorecover location is set for all files - change it for one, you change it for all.How do I add a signature?0 -
Either use a macro within each Excel sheet to change the autorecover value or Google for a sript to do it.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards