+ Reply to Thread
Results 1 to 2 of 2

delete raw+pivot table

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    east
    MS-Off Ver
    Excel 2003
    Posts
    1

    delete raw+pivot table

    Hi,

    when I delete one raw in my datasheet which is no longer needfull, I cannot refresh anymore my pivot table. I have to re-set manually the range in the table wizard, and then it becomes possible to refresh.

    Any idea to fix this issue on excel 2003?

    Tks for your help

  2. #2
    Forum Contributor
    Join Date
    11-07-2012
    Location
    .
    MS-Off Ver
    2003 - 2013 for Windows
    Posts
    121

    Re: delete raw+pivot table

    Hello,

    If your source data structure changes, you may want to use a dynamic data source for the pivot table. In Excel 2003 you can use a List or range names. For details, see Debra Dalgleish's tip at www.contextures.com here: Excel Pivot Table -- Dynamic Data Source
    regards, LMP

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1