Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Meanwhile, I found the solution: The coding for the source of the Pivottable is (of course) contained in the file of the spreadsheet that contains the Pivottable with the extension *.ods. This file is actually a zip file, i.e. in the compressed file format "zip". So:

  1. Unzip this file. (In Linux Mint I do it with the application FileRoller – German: Archivverwaltung –, but of course you can use any program that unzips.) The unzipped file contains several folders and files, one with the name "content.xml".
  2. Open "content.xml" with a text editor. (I used either LibreOffice Writer or the Notepad-like xed.)
  3. With the Search&Replace function find the name of the old "Registered Database" and replace it with the new "Registered Database". Do this for every Pivottable in your spreadsheet.
  4. Save and close.
  5. Zip the file again with a Zip utility.
  6. When you open your workbook now, it works with the new source.

This only works if the new source (the new registered database) has the same exact structure as the old one, of course, because the Pivottable relies on the database's exact structure.

Meanwhile, I found the solution: The coding for the source of the Pivottable is (of course) contained in the file of the spreadsheet solution. This solution should work on any operating system, i.e., on Windows, Linux, or any other.

For a solution we use the file on disk that contains the Pivottable with spreadsheet. It has the the extension *.ods. This file is actually a zip file, i.e. in the compressed file format "zip". So:

  1. Unzip this file. (In Linux Mint I do it with the application FileRoller – German: Archivverwaltung –, but of course you can use any program that unzips.) The unzipped file contains several folders and files, one with the name "content.xml".
  2. Open "content.xml" with a text editor. (I used either LibreOffice Writer or the Notepad-like xed.)
  3. With the Search&Replace function find the name of the old "Registered Database" and replace it with the new "Registered Database". Do this for every Pivottable in your spreadsheet.
  4. Save and close.
  5. Zip the file again with a Zip utility.
  6. When you open your workbook now, it works with the new source.

This only works if the new source (the new registered database) has the same exact structure as the old one, of course, because the Pivottable relies on the database's exact structure.