Erroneous Data when increasing sheet size

CordingBags

New Member
Joined
Mar 7, 2022
Messages
37
Office Version
  1. 2016
Platform
  1. Windows
I have what I think of as quite a large worksheet, in a 5 sheet workbook.
This sheet is a Data Entry page for calculations on the other four sheets within the workbook.
I now need to almost double the width of this sheet, from columns K to DV to cover the columns K to IV
Row 4 contains the date for the entries within that column.

Surprisingly as soon as I add a new date the sheet almost seems to count the new entry and instead of appearing as a standard date, it is appended by a number, this number increasing as I add further dates.
Doesn't seem to matter how I format the dates I still get this additional "count number" appended.

If it is relevant the sheet is formatted as a table to enable filtering.

Any suggestions?
1647465928731.png
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
I have what I think of as quite a large worksheet, in a 5 sheet workbook.
This sheet is a Data Entry page for calculations on the other four sheets within the workbook.
I now need to almost double the width of this sheet, from columns K to DV to cover the columns K to IV
Row 4 contains the date for the entries within that column.

Surprisingly as soon as I add a new date the sheet almost seems to count the new entry and instead of appearing as a standard date, it is appended by a number, this number increasing as I add further dates.
Doesn't seem to matter how I format the dates I still get this additional "count number" appended.

If it is relevant the sheet is formatted as a table to enable filtering.

Any suggestions?
View attachment 60256
Removing the dates across the range produces Column count.
1647466535949.png
 
Upvote 0
As I suspected this is exactly because the sheet is formatted as a table, the header row MUST contain unique values. Hence the suffix.
 
Upvote 0
Solution

Forum statistics

Threads
1,214,561
Messages
6,120,239
Members
448,951
Latest member
jennlynn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top