My Online Training Hub

Microsoft Office Online Training

Get our newsletter and join over 80,000
people who learn Excel with us every week
You are here: Home / Can the Data Source be Updated from a Pivot Table? | Power Pivot | Excel Forum

Can the Data Source be Updated from a Pivot Table? | Power Pivot | Excel Forum

Avatar
sp_Registration Register sp_LogInOut Log In sp_ControlOpen Unanswered
sp_Search Search
Advanced Search
Search

— Forum Scope —





— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Search Search
sp_RankInfo

Lost password?
sp_PrintTopic sp_TopicIcon
Can the Data Source be Updated from a Pivot Table?
Avatar
jaynemae
Member
Xtreme Pivot Tables

Members

Power Pivot
Level 0
Forum Posts: 3
Member Since:
July 6, 2016
sp_UserOfflineSmall Offline
1
July 6, 2016 - 10:59 pm
sp_Permalink sp_Print

I am using MS Excel 2010. Is there any known way to update the data table directly from a pivot table? In other words, I would like to be able to change a figure in a pivot table and have this change automatically reflect back to the data table. Is this even possible?

Avatar
Catalin Bombea
Iasi, Romania
Admin
Level 10
Forum Posts: 403
Member Since:
November 8, 2013
sp_UserOfflineSmall Offline
2
July 7, 2016 - 3:07 am
sp_Permalink sp_Print

Hi,
A pivot table is not editable unfortunately, it will only take data from source, it will never send data to source.
Catalin

Avatar
jaynemae
Member
Xtreme Pivot Tables

Members

Power Pivot
Level 0
Forum Posts: 3
Member Since:
July 6, 2016
sp_UserOfflineSmall Offline
3
July 7, 2016 - 9:48 pm
sp_Permalink sp_Print

I was afraid that someone would verify that. Darn, now my bubble has completely burst! Confused Thank you for taking the time to respond. I do appreciate your response.

Go to top
Forum Timezone: Australia/Brisbane

Most Users Ever Online: 57

Currently Online: Meyanui
20 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 651

Frans Visser: 210

David_Ng: 96

mey tithveasna: 71

A.Maurizio: 60

rathanak: 58

yhooithin05: 54

Anders Sehlstedt: 47

julian: 46

PaulFogel: 37

Newest Members:

Akshatraj Adig

Liesie Marais

Moet Lewis

Michelle Anderson

Veronica Gallego

krishnaraj r

Dharan Prakash Mishra

Md. Rahman

Lilian Vo

Jane Kumwenda

Forum Stats:

Groups: 2

Forums: 18

Topics: 935

Posts: 4405

 

Member Stats:

Guest Posters: 1

Members: 42350

Moderators: 1

Admins: 3

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea

Moderators: Genevieve Tupas

YouTube Channel Follow us on Facebook Twitter Follow Google+ RSS Feed or Email

Blog Categories

Resources

Excel Resources

Affiliate Program

Become an Affiliate
Secured by Sucuri Rect
✕
Hang On, Don't Go Just Yet.
Excel Tips & Tricks Book

As a thank you for visiting how would you like a
10% Discount Code to use with any of my courses?

I'll also give you a copy of my eBook packed with
100 Excel Tips & Tricks.

And I'll send you my weekly Excel blog posts.

Enter your email address below to receive all of these.

Regards, Mynda (Excel MVP)

mynda treacy mvp
100% Privacy. We don't spam.
✕
SUBSCRIBE AND LEARN EXCEL
Excel Tips & Tricks Book


Learn great Excel features, tips and tricks each week from my newsletter.

Just enter your email below, and as an extra bonus, I'll send you a copy of my '100 Excel Tips & Tricks eBook' - for nothing!

Thanks,

Mynda

 



100% Privacy. We don't spam.
✕
100 FREE EXCEL TIPS & TRICKS
Excel Tips & Tricks Book


Want to learn more great Excel tips and features?

Enter your email below and I'll send you my weekly blog post.

Plus, by signing up you'll get a copy of my '100 Excel Tips & Tricks eBook' - for nothing!




 

100% Privacy. We don't spam.