Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot tables

ResolvedVersion 2003

Stuart has attended:
Excel Advanced course

Pivot tables

How comes data goes missing if two pivot table are open?

RE: pivot tables

Hello Stuart
Thank you for your question

I have never heard of this, underlying data should not go missing as long as the pivot table you created does not sit directly on the data fields it links to. Are you sure that the Pivot table isn't sitting on the data by mistake? Try recreating the Pivot tables from scratch and placing them on a seperate tab. Does the problem still happen?

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Excel tip:

Paste a web address into the hyperlink address field

If you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.