Formula won't copy down in Excel table

[csenor]

Hello all. I have a large dataset with 30 columns of data and over 1,000 rows. The table used to get updated by a connection to an Access database. I also have a column controlled by a macro that updates the date if something in the row was changed. It is formatted as an Excel table and was before I disconnected it from Access. No formulas will copy down any longer. Any suggestions?



If I highlight the entire table and convert to a range and turn it back into an Excel Table, is anything going to get messed up?

 

[Fluff]

One reason formula won't copy down automatically, is if the column does not contain the same formula in every cell.

Converting to a range might be ok, but when you turn it back to a table, any formula that looks at the table will use normal references, rather than table references.
Not sure what would happen however if you have any pivots or PQ looking at the table.

 

[csenor]

One reason formula won't copy down automatically, is if the column does not contain the same formula in every cell.

Converting to a range might be ok, but when you turn it back to a table, any formula that looks at the table will use normal references, rather than table references.
Not sure what would happen however if you have any pivots or PQ looking at the table.

So I copied all of the data from my table and pasted just values into a new sheet. Created a new table. Remade my first formula to concatenate names in the columns next to it. When I hit enter, it didn't copy down. I double clicked on the bottom right and it copied down to the second to last row where I was hoping it would copy the formula and concatenate the last row. It stopped at the second to last row.

I tested it again by making another range of two date columns somewhere else on the sheet and converting that to an excel table. I made a third column and did a logical test to see if numbers existed in each row. The formula worked there. Why won't the dates in my real dataset be recognized as numbers?

 

[Fluff]

Are they actual dates or text? If you format the cells as general, do you see a date or a 5 digit number.