Forum Discussion
Changing the data source file - best practice?
Thanks for your input.
Yes it is but I have just cracked it.
Basically, the item named in the error is the sheet name so once I changed that over it has remedied it. The only issue is that I need to change data source and worksheet name under every tab in Navigation step now.
I think I will simply need to remember to rename worksheet every time I download the source file to something common amongst all queries as I do with the filenames generally. Even when setting a new project up, it is clearly important to maintain a level of consistency in naming conventions.
Is the new spreadsheet saved in the same location as the old one? If not, that could be causing the error
Thanks for your input.
Yes it is but I have just cracked it.
Basically, the item named in the error is the sheet name so once I changed that over it has remedied it. The only issue is that I need to change data source and worksheet name under every tab in Navigation step now.
I think I will simply need to remember to rename worksheet every time I download the source file to something common amongst all queries as I do with the filenames generally. Even when setting a new project up, it is clearly important to maintain a level of consistency in naming conventions.