Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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???
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivottable - Accessing file from network Todd1 Excel Discussion (Misc queries) 0 March 29th 06 02:33 AM
I inserted a field =Amount1 - amount2 -PivotTable-doesn't work mark ivanowski Excel Discussion (Misc queries) 0 March 21st 06 08:40 PM
network save msg overwrite or make copy Bill Stenzel Excel Discussion (Misc queries) 0 July 28th 05 07:44 PM
Pivottable across network mmwheeler Excel Worksheet Functions 0 July 26th 05 02:36 PM
Why doesn't Save as work over the network? LLL Excel Discussion (Misc queries) 5 February 24th 05 06:26 PM


All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"