×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel pivot table refresh says Invalid Pivot Table report

Excel pivot table refresh says Invalid Pivot Table report

Excel pivot table refresh says Invalid Pivot Table report

(OP)
I created an Excel workbook that queries a SQL Server database that returns around 500,000 to 600,000 rows. He then refreshes a Pivot Table references query data. You can successfully refresh the Pivot Table immediately after the refresh. When he saves the workbook and reopens it, though, attempting to work in the pivot table returns the error:

This Pivot Table report is invalid. Try refreshing the data.

He can dutifully refresh the data, but it doesn't make the problem go away. It seems that if he re-creates the Pivot Table from scratch, it works for one more work session, the problem recurs the
he opens the workbook. It's a fairly complex pivot table, so rebuilding it all the time isn't making him happy.

A few Google searches turn up information on some other Pivot table problems with field names, but not for the whole Pivot table report being invalid.

Any information on that error?

-
Richard Ray
Developer, Data Analyst
Jackson Hole, WY

RE: Excel pivot table refresh says Invalid Pivot Table report

What excel version? When the pivot table was created, did you created data in data model?
If you use excel 2016+, have you considered power query connection (if you don't need data model, but even in this case you can have a series of query outputs in data model)?
Is it an issue described here?

combo

RE: Excel pivot table refresh says Invalid Pivot Table report

(OP)
Excel from current Office 365. No Power BI tools in use. Data not added to Data Model. I’ll take a look at the link you suggested.

-
Richard Ray
Developer, Data Analyst
Jackson Hole, WY

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close