Do you want to play a crucial role in shaping Jet Global products?
This idea has been merged into another idea. To comment or vote on this idea, please visit JETPRO-I-136 Define fix datasource expression for all formulars in one Excel file.
For those of us that use multiple data sources (i.e direct, data warehouse, cubes) Jet Pro always uses the last use source. It doesn't save the data source with the workbook and even switches the data sources as you switch between open workbooks.
Allow us to put the default datasource in a cell, perhaps in the parameters page. If that value exists, than use that datasource for all queries in the workbook.
Right now the only way is to specify a datasource in every single formula used i the workbook.
I see that you saw the similar idea that was already posted. I am going to merge your idea to this one which will add your vote to it. Thank you for your contribution.
Attachments Open full size