This message may also appear if you click VBAProject Properties on the Tools menu in the Microsoft Visual Basic Editor.
The maste file updates automatically every 10 seconds based on some code in the master file.
However, the shared workbook function in Excel (tools/share workbook) limits the shared automatic updates to every five minutes (at the least).
I get two messages: Excel does not permit exporting to a protected or shared workbook. OK - I can live with that, but why can I not replace the entire page? Hi impossible, Have you tried the steps in the following FAQ: https://support.quickbooks.intuit.com/support/articles/sln75462Let me know and we can investigate further.' data-inline-edit-type='wysiwyg' data-inline-edit-url='/answers/2512728' id='inline_edit_answer_2512728_body' Yes. It states that "QB does not support updates for this type of report". This is a report created in QB and exported to Excel. People come to Quick Books Learn & Support for help and answers—we want to let them know that we're here to listen and share our knowledge.
As I said in my original post, the workbooks are not protected or shared. Not only can the report be re-imported into QB, but it cannot be updated. We do that with the style and format of our responses.
Note Not all features are fully supported in a shared workbook.
If you want to include any of the following features, you should add them before you save the workbook as a shared workbook.You can keep track of the changes other people make and accept or reject those changes. On the Review tab, in the Changes group, click Share Workbook. The screen above shows you who has the workbook open. On the Review tab, in the Changes group, click Track Changes. Note: not all features are available in a shared workbook.There will be a varying number of rows in each of the individual sheets.