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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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,215,046
Messages
6,122,849
Members
449,096
Latest member
Erald

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