Forum Discussion
Can pivot value field be auto-updated?
I have a pivot table where the values fields are dependent on formulas. Is there away to auto-update the value in the Values field when the formula value updates? I need to have the error added to t...
See if you can install Power Query from here
https://www.microsoft.com/en-au/download/details.aspx?id=39379
https://www.microsoft.com/en-au/download/details.aspx?id=39379
Says I need at least 2010 SP1, which I do not have :( All updates are controlled by our HQ IT dept.
- sure
I appreciate your help. I'll be upgrading to a new laptop in the next few weeks and will pick this up where we left off if that's ok :)
- That's a shame.
Unfortunately I don't have any other suggestions that are practical here. It could be done with some complex VBA/Macro but that would be time consuming to develop.
I'd suggest you repost this question asking if there is a VBA solution to your problem given you don't have access to Power Query.