<div>
How are you pulling in the data from the other source?<br />
<br />
Once it's in you can dynamically redefine the range. &nbsp;Recording a macro defining the range will give you the guts of it. &nbsp;If you post back what you get, then someone can set it up to make the range dynamic.
</div>


How are you pulling in the data from the other source?

Once it's in you can dynamically redefine the range.  Recording a macro defining the range will give you the guts of it.  If you post back what you get, then someone can set it up to make the range dynamic.

<div>
<div class="content wysiwyg-content">
I created a Name in the Name Manager to cover a large range.<br />
<br />
Every week I have to replace the data with fresh data from another source.<br />
<br />
When I go to my pivot to refresh, I have to tell the Name to get the range again.<br />
<br />
How can I get a range of the entire spreadsheet so I can refresh new data?
</div>
</div>


I created a Name in the Name Manager to cover a large range.

Every week I have to replace the data with fresh data from another source.

When I go to my pivot to refresh, I have to tell the Name to get the range again.

How can I get a range of the entire spreadsheet so I can refresh new data?

Name Manager: How can I get a range of the entire spreadsheet so I can refresh new data?

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.