How to refresh pivot table without having trouble on reference?

Asked By willie revillame 0 points N/A Posted on - 11/04/2011

Whenever I try updating the Pivot Table using the Refresh Data key, I kept on receiving the error message saying “Reference is not valid”. Is there anything I can do to refresh the data?

I hope you can help me. Thank you. 

• Status: Open
• Question Views: 804
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By lee hung 75 points N/A #105204

How to refresh pivot table without having trouble on reference?

Hallo Willie,

Is the refreshing key you are using F5? I will advice that you unplug the keyboard and plug it in again, maybe it has just frozen.

Otherwise try closing the application that you are using for updating the pivot table and then launch it again. Ensure that when pressing the refresh key on the keyboard which should be F5 you are not holding down other keys at the same time, because you may be using a key combination that does no have really exist.

I hope this helps you fix your problem.

__

Regards
Lee Hung

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 11/04/2011
• Question Category: MS Access