Reference isn't valid - refresh all
Hi,
I have a pivot table, which is showing an error 'Reference isn't valid' when I click on 'Refresh All'. The data behind the pivot table is pulling off a SQL database, into Power Query, and the output from Power Query is then being put into a Pivot Table.
Very annoying error!
Do you have any other data sources in the workbook? What happens if you manually refresh each data source, then manually refresh the pivot table? Still get an error?
hiiii, i have same problem here..Originally Posted by teylyn
when i try to refresh manually one by one, there is no error happen.. reference isn't valid only happen when i try to refresh all
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks