I have a document that pulls from several data sources to generate pivot tables. I have a sub to copy the sheet 'finished' and save it as a new workbook in a network location after creating the folder. It worked fine until randomly this started popping up regardless of what backup I open. Just keeps saying "Save 'Book1' with references to unsaved documents?"
I tried to locate the error files in the temp folder but I couldn't locate anything like the various websites mentioned. I only have connections that are necessary for the pivot tables and ones I set up myself. I don't have any named ranges or anything like that. Can you guys tell me where I'm going wrong?
Bookmarks