Skip navigation

Replace data source for selected worksheets in a workbook

score 5
You have not voted. Active

Currently you can replace one data source for another data source, where it replaces the data source across every worksheet in the entire workbook that is using that original data source.


In some cases you may want to develop with a new data source across only some of your sheets (e.g. copies of worksheets) whilst maintaining the original data source for other worksheets.


A good use case is being able to test changes to an original data source (where the changes are applied to the second data source) and replace the original data source in copies of your given worksheets.


Here is how I envisage a potential solution:



Vote history