View My Drafts
Hi to my Excel guru friends!I created a spreadsheet to track sales opportunities in Excel. I used power query to combine tables on different tabs into one table that then drives several graphs on a dashboard. When others open, modify and save the file on the shared drive, the next person who opens it sees this error:We found a problem with some content in 'file name.xlsm'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.Upon clicking yes, a box pops up that says Excel was able to open the file by repairing or removing the unreadable content, and lists Removed part: drawing1.xml part (drawing shape) ...which seems to be the dashboard graphs that were removed.Any idea what causes this, and how to prevent? We think it may have something to do with this question "Do you want to make this file a Trusted Document?", which is answered differently by each user (even though we have instructed them to say "yes").Thanks so much!