Hello All,

I have a rather tricky problem that I'm trying to solve using VBA.

I have one spreadsheet which acts as a data source "parent" and is linked to three "child" spreadsheets containing charts. Whenever a user opens one of the child spreadsheets, he or she gets the dialog box asking if they want to update the linked data. My goal is the change the child spreadsheets so that when a user opens them manually (i.e. not with VBA code), they do not get this "update linked data" dialog.

More specifically, I want to have a VBA script which does the following steps:

1) Open all spreadsheets in a give directory
2) Remove all links to other workbooks and leave static data
3) Save the spreadsheet
4) Close the spreadsheet

This has to work for any set of spreadsheets, regardless of whether they're linked to other spreadsheets or not.

Is there a way of doing this that anyone can think of?

Thanks in advance,

Ben Holton