Geeta2014
New Member
- Joined
- Aug 9, 2014
- Messages
- 16
- Office Version
- 2019
- 2016
- 2010
- Platform
- Windows
if i open file in 2010, filter works [file was likely created using 2010 excel]
same exact file - I open using Excel 2016, filter does not work.
the column has h:mm formatting and is dependent on a calculation. the result in the cells throughout the column are very large negatives [16 decimal places]. any ideas anyone? FYI - I am an experienced Excel user and do have multiple workarounds - so please do not provide a workaround. I am looking to identify the reason why this works in an older Version of Excel but not in a newer version. Has anyone come across this? if so, do you know specifically how the two version differ? my instinct is it is a microsoft issue.
same exact file - I open using Excel 2016, filter does not work.
the column has h:mm formatting and is dependent on a calculation. the result in the cells throughout the column are very large negatives [16 decimal places]. any ideas anyone? FYI - I am an experienced Excel user and do have multiple workarounds - so please do not provide a workaround. I am looking to identify the reason why this works in an older Version of Excel but not in a newer version. Has anyone come across this? if so, do you know specifically how the two version differ? my instinct is it is a microsoft issue.