Databases Reference
In-Depth Information
In the
Saved
folder, you have a folder which has the same name as the Microsoft
Excel workbook name and inside that folder there are three folders called
Sheet
1
,
Sheet 2
, and
Sheet 3.
These
folders correspond with the number of sheets in
your workbook. Inside each individual sheet folder you can save the connection
information and POV for that sheet. Once you save the Microsoft Excel file the
connection information is also saved and this can be used by the business user
to save and then share their queries with other users.