I have an excel spreadsheet which is linked to an access database. When I open the spreadsheet the data is automatically updated from the database. Each month I want to generate a report by saving the spreadsheet and caputuring the information that was imported. If I save the spreadsheet under a different name the link is not removed and the next time I open up the report the next time the data is updated. Is there a simple way to stop this from happening either in the excel main menu or usinng vba without having to go into the connections and breaking each connection?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Save Imported data
0
Answers
0
One simple way to do it, depending on your data, is to save the new file and then select all the data and hit: Ctrl + C and then Alt + E + S + V and then Enter. That will copy/paste-special values so everything you will will simply remain that way.
You could also do it with a custom save button that is attached to a macro but that depends on if you can edit the workbook that does the importing or not.