Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-26-2014, 09:48 PM
intelli intelli is offline Have to rename file every time to save workbook Windows 8 Have to rename file every time to save workbook Office 2013
Novice
Have to rename file every time to save workbook
 
Join Date: Mar 2014
Posts: 2
intelli is on a distinguished road
Default Have to rename file every time to save workbook

Hi everyone,



One of our users keeps getting the following error everytime she tries to save a workbook (attached).

I've tried changing the Offline edition options so the pc doesn't use the Office Document Cache, but the error still appears.

The user is running Windows 8.1 Pro and Office 2013.

Any ideas?

Thanks,

Intelli
Attached Images
File Type: png excel-save-error.PNG (9.7 KB, 15 views)
Reply With Quote
  #2  
Old 03-26-2014, 11:03 PM
RudiS RudiS is offline Have to rename file every time to save workbook Windows 8 Have to rename file every time to save workbook Office 2013
Novice
 
Join Date: Mar 2014
Posts: 10
RudiS is on a distinguished road
Default

Hi,

The error points to the file being read-only. Is the file on a shared network? Check to make sure nobody else has it open. You can also check if the file properties determines if it should open as read-only. Right click the file in Windows (File) Explorer and check the properties of the file (and the folder/directory it's in) is marked as read-only. One other option to check is if the file has a read-only password connected to it that forces it to open as read-only if no password is provided. Click on the File Ribbon Tab and click on the Protect Workbook button on the Info page. Check if the file has encryption on it, and remove it if it is not needed.
Reply With Quote
  #3  
Old 03-27-2014, 10:43 PM
intelli intelli is offline Have to rename file every time to save workbook Windows 8 Have to rename file every time to save workbook Office 2013
Novice
Have to rename file every time to save workbook
 
Join Date: Mar 2014
Posts: 2
intelli is on a distinguished road
Default

Quote:
Originally Posted by RudiS View Post
Hi,

The error points to the file being read-only. Is the file on a shared network? Check to make sure nobody else has it open. You can also check if the file properties determines if it should open as read-only. Right click the file in Windows (File) Explorer and check the properties of the file (and the folder/directory it's in) is marked as read-only. One other option to check is if the file has a read-only password connected to it that forces it to open as read-only if no password is provided. Click on the File Ribbon Tab and click on the Protect Workbook button on the Info page. Check if the file has encryption on it, and remove it if it is not needed.
Hi Rudi,

THanks for the suggestion. Unfortunately the file had no password. The file is located on the users C: drive and it's not set to read only.

Can you suggest anything else I could check?

Thanks again,

INtelli
Reply With Quote
  #4  
Old 03-27-2014, 11:53 PM
RudiS RudiS is offline Have to rename file every time to save workbook Windows 8 Have to rename file every time to save workbook Office 2013
Novice
 
Join Date: Mar 2014
Posts: 10
RudiS is on a distinguished road
Default

The file must have a read only status.
Can you check if the status bar on the file shows [Read Only]. (See image)
If this is the case, Excel will always save it as read only.

1.jpg
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to save a workbook without the macros OTPM Excel Programming 1 01-15-2014 12:42 PM
Have to rename file every time to save workbook Rename Document & Save d4okeefe Word VBA 4 05-23-2013 09:35 AM
PowerPoint Crashes every time I try to save/save as Crimson_Ninja PowerPoint 0 05-04-2011 01:54 PM
Have to rename file every time to save workbook Rename File cksm4 Word VBA 2 02-25-2011 09:29 AM
Have to rename file every time to save workbook code to save / rename / send attachments unit213 Outlook 1 09-26-2007 08:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft