Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlink to other Data sources with code?
I'm sending reports out, but when people go to open them, a message comes up and says "This workbook contains links to other data sources" and I have an option to update and not update. I would really like this not to come up at all, since I'm sending this out to a lot of people and would prefer them not to see that screen. I pulled in data from a database to make the reports. IS THERE CODE I CAN ADD TO THE END OF MY MACRO TO REMOVE THE LINK TO THE DATA SOURCE SO THAT THIS DOESN'T COME UP AT ALL? On a side note, I thought it might be nice to set a report up and then just go in and click update to update from the data source. Always when I hit update it says that it could not be updated, anyone have any idea why that would be? Thanks, ~J -- nbaj2k ------------------------------------------------------------------------ nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480 View this thread: http://www.excelforum.com/showthread...hreadid=572258 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where are the links to other data sources? | Excel Discussion (Misc queries) | |||
links to other data sources | Excel Worksheet Functions | |||
Sources of Excel Tips, Tricks & Code | Excel Discussion (Misc queries) | |||
populating excel cells with data from data sources | Excel Programming | |||
Outside Data Sources | Excel Programming |