Share via

getpivotdata excel table not automatically updating with changes in Pivot data cell value. Getting a #REF! error.

Anonymous
2024-09-19T17:01:36+00:00

getpivotdata excel table not automatically updating with changes in Pivot data cell value. Getting a #REF! error.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-09-20T17:18:13+00:00

    You may create a support ticket to Microsoft. Support engineer can remote to help you on it.

    Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

    Get support - Microsoft 365 admin | Microsoft Learn

    About how to find the admin in your organization, you can refer to How do I find my Office 365 admin

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-09-20T12:54:22+00:00

    Thanks for the response. Unfortunately, its such a huge file, tabs are linked and the formula itself has sensitive info that cannot be screened out or posted. Is it possible to do a screen share and to show you Live and resolve the issue together? Thank you

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-09-20T02:46:55+00:00

    Could you sharea test file to reproduce your issue? Then I can help you correct it.

    For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.

    *Please make sure you have removed any sensitive or private information in the sample file before uploading.

    Was this answer helpful?

    0 comments