Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2024, 01:48 PM
tomohawk tomohawk is offline Pivot Tables Not Recognising a Section of Data In A Table Windows 10 Pivot Tables Not Recognising a Section of Data In A Table Office 2019
Advanced Beginner
Pivot Tables Not Recognising a Section of Data In A Table
 
Join Date: Sep 2020
Location: Dublin
Posts: 60
tomohawk is on a distinguished road
Default Pivot Tables Not Recognising a Section of Data In A Table

I have a spreadsheet where I manage expenditure from my bank accound (and cannot therefore share the data).
At the end of every month I copy the data to a new sheet and transform some of the data (I change negative valued to positive values)
I then take the transformed and copy it and paste/append it to an existing table of previous transactions.
I then have several Pivot tables to collate the data.



I've been doing this for years without issue, except for this month. When I refreshed the Pivot Tables, the new data was not included and I noticed that the Slicer did not include the month for the latest data.

I've done the following checks:-
The new data appended to the base table is included in the table range
The date is in the correct format dd/mm/yyyy
Reply With Quote
  #2  
Old 12-02-2024, 12:08 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Pivot Tables Not Recognising a Section of Data In A Table Windows 10 Pivot Tables Not Recognising a Section of Data In A Table Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Posting a sample sheet would have helped ( no pics please). We now can only try guessing. As for your dates, the format might be correct but are they real dates? YOu van verify this if the dates are right-aligned in the cell when no manual alignment is applied
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 12-02-2024, 02:05 AM
tomohawk tomohawk is offline Pivot Tables Not Recognising a Section of Data In A Table Windows 10 Pivot Tables Not Recognising a Section of Data In A Table Office 2019
Advanced Beginner
Pivot Tables Not Recognising a Section of Data In A Table
 
Join Date: Sep 2020
Location: Dublin
Posts: 60
tomohawk is on a distinguished road
Default

Thanks Pecoflyer

Yes - they are dates. When I Clear>Clear Formats, I get a numerical value

I tried creating a new Pivot Table from the existing Data Table and I only have an option for Date. I do not get an option for Date (Month). I'm assuming this is the issue, but I have no idea how to fix it.
Reply With Quote
  #4  
Old 12-02-2024, 02:15 AM
tomohawk tomohawk is offline Pivot Tables Not Recognising a Section of Data In A Table Windows 10 Pivot Tables Not Recognising a Section of Data In A Table Office 2019
Advanced Beginner
Pivot Tables Not Recognising a Section of Data In A Table
 
Join Date: Sep 2020
Location: Dublin
Posts: 60
tomohawk is on a distinguished road
Default

UPDATE:
When I created the new Pivot Table and actually selected the Date as one of the rows, miraculously, the Date (Month) option was added to the Pivot Table Fields selection pane.

I am now able to Pivot the data for the new month just added.

I've been doing this for years and never had this issue before, so don't know what happened.

Thanks for the support Pecoflyer
Reply With Quote
  #5  
Old 12-03-2024, 12:14 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Pivot Tables Not Recognising a Section of Data In A Table Windows 10 Pivot Tables Not Recognising a Section of Data In A Table Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

You're welcome
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Tables Not Recognising a Section of Data In A Table Not sure how to display this data in a pivot table makaveli80 Excel 8 04-04-2018 11:24 AM
Combine multiple tables into one pivot table in order to do trend analysis marelisev Excel 2 04-15-2017 08:30 AM
Pivot Tables Not Recognising a Section of Data In A Table Data not showing in Pivot Table MichelPierre Excel 2 01-26-2016 10:51 AM
Pivot Tables Not Recognising a Section of Data In A Table Extracting data, pivot tables, and maybe VBA help? rbexcelhelp Excel Programming 3 05-09-2015 12:13 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 06:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft