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.
Karen described a problem in which a shared workbook, stored on a company network, periodically loses all the data it previously contained.
In trying to track down the problem Karen did tests where she and her coworkers tried to open the file at the same time and save it at the same time, but all the tests left the data intact.
by the way, can you please explain me where exactly to paste your coding and what are the basic steps that I need to follow before I do this.? Send 'send message 'give conformation of sent message Msg Box "insert confirmation box test here", , "title of confirmation box" End If 'save the document 'Me. Save End Sub Hi Shark, I'm glad I stumbled upon this thread after long attempts at trying to close in on my solution.
As new customers are added in QB, the Custom Memorized reports are being updated correctly. I tried both Updating a worksheet and replacing a worksheet. The second message is: QB does not support updates for this type of report. Do I have to create new workbooks each time I have to update the Customer lists?
This leads to the first suggestion: don't share the workbook.
If you "unshared" it, then only a single person can open the workbook at a time, which reduces complexity and decreases the chances of corruption.
(The 'Share Workbook' dialog box appears.) 5) Select the 'Allow changes by more than one user at the same time. 8) Under 'Update changes', select the appropriate option. (The 'Microsoft Office Excel' message appears.) 10) To save the workbook, click 'OK'.
11) Click the 'Microsoft Office' button and click 'Save As'.