Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2014, 03:47 AM
KevinD KevinD is offline Seperating Excel from Pivot Windows 7 64bit Seperating Excel from Pivot Office 2007
Novice
Seperating Excel from Pivot
 
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
  #2  
Old 11-12-2014, 07:47 AM
Catalin.B Catalin.B is offline Seperating Excel from Pivot Windows Vista Seperating Excel from Pivot Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 11-12-2014, 07:56 AM
KevinD KevinD is offline Seperating Excel from Pivot Windows 7 64bit Seperating Excel from Pivot Office 2007
Novice
Seperating Excel from Pivot
 
Join Date: Nov 2014
Posts: 2
KevinD is on a distinguished road
Default

Hi Catalin!

Thank you for your help, it worked! And it really was that easy.

Cheers!
Kevin
Reply With Quote
  #4  
Old 11-12-2014, 08:13 AM
Catalin.B Catalin.B is offline Seperating Excel from Pivot Windows Vista Seperating Excel from Pivot Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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
Reply With Quote
Reply

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 Excel from Pivot 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
Seperating Excel from Pivot Is this sort of pivot possible in the Excel? Jamal NUMAN Excel 4 02-14-2012 02:48 PM
Seperating Excel from Pivot Excel 2010 Pivot Table Qs SchneeBaer Excel 2 10-03-2011 08:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft