“You do not have a model or the model is empty” – Not really true – #PowerPivot

Power Pivot in Excel sometimes gives me this frustrating model even though my workbook actually does have a Power Pivot model, when I clicked Calculated Fields – Manage Calculated Fields.

Previously I then closed the workbook and Excel and tried again and it usually helped.

But there is actually a workaround that doesn’t require a restart of Excel.

If you click ok in the dialog – then choose Calculated Fields and “New Calculated Field” … the Calculated field dialog appears


Click Cancel and try the “Manage Calculated Fields” again … and now Power Pivot suddenly can find the model

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s