View Single Post
 
Old 11-12-2014, 03:47 AM
KevinD KevinD is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Nov 2014
Posts: 2
KevinD is on a distinguished road
Default Seperating Excel from Pivot

Hi there!

I am new to this forum. First of all: Hi out there!

Now my question. I am using Excel 2007 and I have a problem with seperating an Excel-file from a pivot table.

What I want to do:
I got my Excel-File and I want to create a Pivot-table out of it. After creating the Pivot-table, I want to seperate it from the native excel-file and save the pivot table for working with it.

What I did:
I created the pivot-table. That wasn't a problem. After creating the pivot table, i right clicked on the tab under it and copied it in another, new excel file. Everything was still fine.
I saved the pivot file, closed it, changed some information in my native excel file and opened the pivot file to check, if updating the pivot file works. But it didn't work, saying it didn't find the connections.

What can I do?


PS: Sorry for my bad english, I hope you understand my problem.

Thanks for any help!
Kevin
Reply With Quote