How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience:  Worked on Macs and PC's for 20+ years.
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

Im user of office for mac 2011 (MacBook Pro Snow Leopard).

Resolved Question:

I'm user of office for mac 2011 (MacBook Pro Snow Leopard). Can you tell me how to update an existing pivot table when appending new records to a source list in the same spread sheet?
Submitted: 6 years ago.
Category: Mac
Expert:  John D replied 6 years ago.



It should work if you use a dynamic named range for the source and used that name as your pivot table source data


Please go to Insert > Name > Define, and select that named range, then copy the offset formula from the "Refers to" field and paste here so I can check it for you



John D and 3 other Mac Specialists are ready to help you
Customer: replied 6 years ago.
Thanks. Should the range include the field labels?
Expert:  John D replied 6 years ago.



Yes include the field labels (assuming the labeling is correct). If have you have any difficulties I will send you step by step instructions