Protected or Shared Worksheet Error Message
Gemma
Member Posts: 60 Reckoner
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.
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.
2
Comments
-
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,
John0 -
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.
0 -
Thanks Gemma,
Is someone else accessing the file at the times you are exporting?
Can you save it to a new excel file?
regards,
john0 -
0
-
0
-
0
-
0
-
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.0
-
0
-
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.0
-
0
This discussion has been closed.
Categories
- All Categories
- 6.7K Accounts Hosted
- 17 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 8 📢 Reckon Accounts Desktop - Announcements
- 1.5K Reckon Payroll
- 40 📢 Reckon Payroll - Announcements
- 15 Reckon Payroll Help Videos 🎥
- 30 Reckon Mate App
- 2.7K Reckon One
- 16 📢 Reckon One - Announcements
- 14 Reckon Invoices App
- 24 Reckon Insights
- 101 Reckon API
- 310 Point of Sale
- 1.9K Personal Plus and Home & Business
- 72 About Reckon Community