Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

 

Merged idea

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.

Setting up a default data source at the workbook level Merged

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.

  • Guest
  • Nov 30 2018
  • Under Consideration
  • Kim Duey commented
    December 03, 2018 14:45

    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.