We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-16 11:23:44.870588

2 Answers

Sort by » oldest newest most voted

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

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

m.a.riosv gravatar image

Is it the database registered?

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 85 times

Last updated: Sep 26 '17