We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Pivot Table Sources
Cotta
Posts: 3,667 Forumite
in Techie Stuff
Afternoon All,
I have a series of Pivot tables within a spreadsheet that seem to feed from a separate spreadsheet - how can I find out where their main source is?
Thank you.
I have a series of Pivot tables within a spreadsheet that seem to feed from a separate spreadsheet - how can I find out where their main source is?
Thank you.
0
Comments
-
It would help if you say what spreadsheet application you are using and which version.
For Excel 2010, if you select the "PivotTable Tools Options" tab, then select "Change Data Source" it should bring up a dialog that tells you where the data is coming from.0 -
Great that's the one - thanks.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.4K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.5K Work, Benefits & Business
- 602.8K Mortgages, Homes & Bills
- 178K Life & Family
- 260.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards