Results 1 to 2 of 2

Thread: Making Pivot Table Dynamic AFTER Creating it

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte Merina's Avatar
    Join Date
    Jun 2021
    Posts
    1
    Articles
    0
    Excel Version
    2017

    Unhappy Making Pivot Table Dynamic AFTER Creating it

    I wasn't using pivots in the past until recently when i changed job. After creating pivot tables and charts, i realized that the tables are not pulling latest data from source table unless i keep changing data source. i have read numerous sites on resolving this, either by creating a named table or by using offset and counta formula. Neither is working. In fact, the source table is not allowing me to use CTR+T to open "create table". I could use offset and counta a formulae on the Name Manager tab option. Yet, the pivots are not updated. Please advise. Thanks!
    Last edited by AliGW; 2021-06-16 at 01:04 PM. Reason: Irrelevant section of title removed - this is a help forum!!!

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,854
    Articles
    0
    Excel Version
    O365
    Not sure why Ctrl-T doesn't work. Can you post the workbook?

Tags for this Thread

Posting Permissions

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