Pivot table not picking up the data from source

		Microsoft Office Forums > Microsoft Excel > Excel
Pivot table not picking up the data from source

FAQ

Thread Tools

Display Modes

01-10-2023, 06:51 PM

Marcia

Windows 11 Pivot table not picking up the data from source

Office 2021

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Pivot table not picking up the data from source

Hi all. I'm going nuts from a pivot table results. The workbook contains tables from 2021 and 2022. One table in one sheet is FY2021, while another table in another sheet is 2022. The headings of both tables are the same. I created a pivot table with FY2022 as the source but it is showing the data from FY2021 not FY2022. Any idea what is causing the wrong information?

Thank you.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail merge picking up data from wrong row	LisaG	Mail Merge	1	01-25-2022 06:52 AM
Changing Existing Pivot Table Source from a DB to a worksheet	chrisdenslow	Excel	3	07-24-2017 05:01 AM
How do I find Source of Pivot Table	bobmayo	Excel	2	05-16-2013 12:42 PM
VBA: Include Dynamic Sheet Name In Pivot Table Source Data	ibrahimaa	Excel Programming	2	04-28-2012 12:27 AM
pivot table source data	hannu	Excel	0	07-03-2010 04:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:10 AM.