Ask Your Question

I cannot open my database sheet, but the pivot sheets shows data extracted from database

asked 2017-09-25 21:11:07 +0200

bebef gravatar image

hello. I cannot open my database sheet, but the other sheets shows the data. Get the error: "Can't open PivotTable source file"

For exemple I have the A database sheet. B and C pivot sheets show the data extracted from the database.

But my database sheet is empty. What can I do to recover (to see) my database again?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-09-25 22:18:02 +0200

m.a.riosv gravatar image

Is it the database registered?

edit flag offensive delete link more

answered 2017-09-26 10:44:32 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I find the answer.

If your pivot table has a Grand Total Row, double click on Grand Total Value, it will create a new sheet with a table having the whole data set for you, this will be an exact copy of the database.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-25 21:11:07 +0200

Seen: 56 times

Last updated: Sep 26 '17