![]() |
Automated Copying without links
I am working on an import routine for users to upgrade their exisiting
workbooks to the new version we are now using. During this procedure a sheet template is copied from one workbook which only contains sheet templates, to the workbook being created in the import routine. Originally this was done internally within the wb under creation, but excel could no longer copy the shet after 34 copies, and the workaround microsoft suggests (saving, closing then reopening the wb) completely breaks the import routine. So, after the import is finished and the wb saved, the This workbook contains links....Do you want to update? message appears. Is it possible to perform the copy procedure without creating these links. If not how can I go about removing these links. I have seen several mentions of other add-ins that will do it for you but I would rather handle this in code myself than install and run aomeone elses add-in. I think my boss would prefer this as well. |
All times are GMT +1. The time now is 09:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com