• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1083
  • Last Modified:

powerpivot slow to load

I have built a powerpivot workbook and every time the user loads it, it runs a process reading and writing OLAP queries.  I update all this data before distribution from an Access DB and want to turn off all the data reads when opening the spreadsheet.  The prompts at the bottom tell me to press escape to stop but I would like to shut this off when I distribute the files as it takes about 20 seconds to load with this process running.
0
vmccune
Asked:
vmccune
1 Solution
 
Zack BarresseCEOCommented:
Hi there,

What version of Excel and Power Pivot are you using? The data model has to load. It shouldn't have to refresh unless you're refreshing it's data connections or pivots, but you can't get away from the model loading.

Regards,
Zack Barresse
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now