ferriemike
New Member
- Joined
- Sep 15, 2014
- Messages
- 1
I'm hoping that someone might help with this.
I'm working on a shared file (.xls) using Excel 2010. It's saved on a network drive and set to backup on save. As expected when the file is saved it creates a "Backup of (filename).xlk" file in the same folder as the original file.
My problem is that this happens only once. When trying to save a second time, a dialog box appears that says "Document not saved" and on closing and checking the file sure enough the changes are not saved. This can be resolved by browsing to the file location and either deleting the xlk file or moving it to another location.
Having to do this is a bit cumbersome and isn't too easy to explain to the user community that is contributing to this file.
Can I specify where the backup file is saved or should I use a different way to backup the file?
Thanks
I'm working on a shared file (.xls) using Excel 2010. It's saved on a network drive and set to backup on save. As expected when the file is saved it creates a "Backup of (filename).xlk" file in the same folder as the original file.
My problem is that this happens only once. When trying to save a second time, a dialog box appears that says "Document not saved" and on closing and checking the file sure enough the changes are not saved. This can be resolved by browsing to the file location and either deleting the xlk file or moving it to another location.
Having to do this is a bit cumbersome and isn't too easy to explain to the user community that is contributing to this file.
Can I specify where the backup file is saved or should I use a different way to backup the file?
Thanks
