Save Imported data

0

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?

Answer
Discuss

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.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login