#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi Kevin,
Wellcome to our forum You have to create the pivot table in the second workbook, and choose the first workbook as the data source. In the Create Pivot Table menu, choose the second option: Use an external Data Source and click the button: Choose Connection. The existing connections window will show up, choose Browse for More, then browse for your data file (choose excel files in the filter). After you select the file, the Select table window will show up. It contains sheet names, not table names, so choose the sheet that contains your table. Make sure that the first row in that sheet is the header row... Cheers, Catalin |
#3
|
|||
|
|||
Hi Catalin!
Thank you for your help, it worked! And it really was that easy. Cheers! Kevin |
#4
|
|||
|
|||
Glad to hear that
Then you can mark your thread as solved. You can do this from Thread tools (on top of this page). Cheers, Catalin |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Average over all pivot rows in excel | Andrey | Excel | 2 | 07-23-2014 07:51 AM |
Seperating text data | philb | Excel | 4 | 10-31-2013 10:37 AM |
Excel Pivot - Do not display rows with zero value | patidallas22 | Excel | 1 | 03-08-2013 01:35 PM |
Is this sort of pivot possible in the Excel? | Jamal NUMAN | Excel | 4 | 02-14-2012 02:48 PM |
Excel 2010 Pivot Table Qs | SchneeBaer | Excel | 2 | 10-03-2011 08:45 PM |