Protected or Shared Worksheet Error Message

  • 2
  • Question
  • Updated 3 weeks ago
I'm using Reckon Hosted.  I've been exporting to the same excel worksheet for weeks and now an error message is appearing:

Excel does not permit exporting to a protected or shared worksheet or adding a sheet to a protected workbook.

Use the Excel Tools menu to change the workbook settings.

The worksheet is a plain XLS file.

Anyone have a solution to this frustrating problem? Not sure why all of a sudden it's doing this. 
Photo of Gemma

Gemma

  • 380 Points 250 badge 2x thumb

Posted 3 months ago

  • 2
Photo of John G

John G, Information Support Analyst

  • 27,290 Points 20k badge 2x thumb
Hello Gemma,

Thanks for asking.

The message accurately describes the situation - the file you are exporting to is protected with a password (in Excel, Review > Protect Workbook).  Reckon Accounts cannot write to such a file.  

You can save your export to a new file.

If you want to continue using the same file then download it to your local PC and remove the protection - Review > Protect Workbook and enter the password. 


Hope it helps.

regards,
John
Photo of Gemma

Gemma

  • 380 Points 250 badge 2x thumb
Hi John

Appreciate your response however the worksheet is definitely not protected with a password.  It's a blank excel document - nothing fancy. 

The problem is hot and cold.  I can be using the same worksheet to export to without any issue and then all of a sudden the error message pops up and I can't export.
Photo of John G

John G, Information Support Analyst

  • 27,290 Points 20k badge 2x thumb
Thanks Gemma,

Is someone else accessing the file at the times you are exporting?
Can you save it to a new excel file?


regards,
john  
Photo of Gemma

Gemma

  • 380 Points 250 badge 2x thumb
Hi John, no-one else is accessing the file.  This problem is ongoing and now one of my colleagues is experiencing the same issue with a worksheet that no-one else is using and is not protected.

It's just happened to me again after using and exporting to the same worksheet all day.

Very frustrating.

The only solution I have found is to completely restart my computer.


Photo of John G

John G, Information Support Analyst

  • 27,290 Points 20k badge 2x thumb
Thanks Gemma for eliminating the protection end of the excel file.  

There are a few issues that may explain your experience.

There is a compatibility issue when the file you are trying to save to was created on your local PC in .xlsx format and uploaded to Hosted.  The upgraded version of Hosted now runs on a Windows Server version that no longer supports the saving by a .xls system (Reckon Accounts) to a .xlsx file.  Such an error can result from it, and it will now happen all the time.  Saving to a new file will not be an issue.

Another possible source is that another user worked with the file and the system did not let it go when they finished to allow another user to save to it.  Saving to a new file will not be an issue

A final possibility is that the native Hosted backup was backing up your file at that particular time and so locking out other users while the backup is in progress.  The error you get is the best fit message but does not describe what is actually happening.  Trying again in a couple of minutes is likely to succeed. saving to a new file will not be an issue.

Rebooting your local PC does not contribute to the solution you obtained; its starting a new Hosted session (that in almost all circumstances puts you on to a different Hosted server), and perhaps the passage of time, that restored your ability to save to the file.  

A workaround you can try is to save to a new worksheet but then select your existing Excel file.  


I hope these explanations help you navigate around the times you encounter this error.


regards,
John.
Photo of Gemma

Gemma

  • 380 Points 250 badge 2x thumb
Thank you John. Appreciate your help.

Photo of Shelley

Shelley

  • 464 Points 250 badge 2x thumb
Im having the same issue.  Work book I'm creating has some 20 pages. (monthly reporting package)
I will have saved some pages to the workbook and then the next page wont be able to be saved as the workbook has been protected.  No-one else has access to the file.
Becoming a time wasting exercises.