ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cannot copy PivotTable to Network, at work. (https://www.excelbanter.com/excel-discussion-misc-queries/131836-cannot-copy-pivottable-network-work.html)

PedroDC

Cannot copy PivotTable to Network, at work.
 
Greetings.

I created a PivotTable (PT) wich accesses an ExternalDataBase txt (EDB), and
enabled "Save data with Table Layout" option.

This EDB is obtained via exporting a table from Access.

The PT works fine. However, I cannot copy it to the local network, at work.

The copy process stalls and a file with the same name is created, however it
is corrupt.


There are, at least, three odd facts involved:

1. My IT colleagues can copy it to the network, taking a copy of the file
from my PC (using a flash drive), and performing the copy process on their
machines.

2. In January, I was using an Access Database (lets call it DB1) and
obtaining external databases in txt format, the same way I'm doing now. I had
a Pivot Table wich used the txt as ExternalDatabase, like now. However, I
never had any problem with the copying to the network phase!

3. Meanwhile, I copied DB1 (thus obtaining a DB2, wich I'm using now),
erased the data from the tables and importing new data (this was done every
month; again nothing new). The copying problem arises with the data I export
from this new table. This is the most weird thing, for me: if I erase the
data from this EDB, maintaing the headers, and copy into it data from, let's
say, December 2006 EDB, THEN I can copy the PT to the network.

What's happening???


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com