Hi. I have multiple pivot tables in one spreadsheet that are looking at the same view in my sql server database using an olap connection.
When I refresh the spreadsheet it takes about 7 minutes to update as each table is pulling the data fresh from the server.
Is it possible to link multiple pivots to the one olap connection to speed up the refresh?
I know this is possible if the data is in excel. But when creating an olap cube it doesn't give me the option to base it on a different pivot table.
I can't pull all the data into Excel as it contains hundreds of thousands of rows
Hoping someone can help me out.
When I refresh the spreadsheet it takes about 7 minutes to update as each table is pulling the data fresh from the server.
Is it possible to link multiple pivots to the one olap connection to speed up the refresh?
I know this is possible if the data is in excel. But when creating an olap cube it doesn't give me the option to base it on a different pivot table.
I can't pull all the data into Excel as it contains hundreds of thousands of rows
Hoping someone can help me out.