• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Give your data source room to breathe

by on
in Excel Training,Office Technology

Q. How can I avoid changing the data source each time my source data grows?

A. Typically, when you create a Pivot Table from an Excel table, you click in the middle of it. Usually, after choosing Insert>Tables>Pivot Table, you just click OK. Next time, observe the Table/Range field in the Create Pivot Table dialog box. It should be set to the dimensions of the data source. Here, you can extend the end of the range by however many rows you think your data might grow to.

There are two alternative procedures. If your Pivot Table has already been created, click Change Data Source on the Pivot Table Tools Options contextual tab and extend the range here in the Change Pivot Table Data Source dialog box. A third option involves naming the range for your data source. Include as many rows as you think your data source will need over time. When you create your Pivot Table or change the data source, replace the range defined with the name of the range. Either method will avoid the problem.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/37104/give-your-data-source-room-to-breathe "

Leave a Comment