Protected or Shared Worksheet Error Message

Gemma

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. 

John G

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

Gemma

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.

John G

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  

Gemma

John G

Gemma

[Deleted User]

Gemma

I still experience the problem every now and then and so do others I work with.  The only solution I have found is to exit out of Reckon and log back in.  That seems to fix it. 

Bronwyn_6928829

Gemma

Hi Bronwyn,  I still get this issue at least once a week.  The only solution I have found is to exit Reckon and log back in.  I struggle to think of any issues I have raised on the forum that Reckon have either responded to or resolved. Unfortunately the support is lacking. 

Bethtx