Hi there

I have a macro that copies from a .csv file and pastes into the bottom of a table in excel. The table is setup so that when I paste to it like this the table grows to include this data, which when I do a refresh all updates all the linked pivot tables linked to this table.

Now the problem is that when I paste the dates in they change to the format mm/dd/yyyy. The format of the date at source is dd/mm/yyyy and the format of the date in the table is dd/mm/yyyy, well it has been up until now. And before today the macro was pasting into the table as dd/mm/yyyy. So I am not sure what has changed!!

Is there some properties to this particular table that has chnaged?
I'm pretty sure my regional settings are unchanged.
It is not a 1904 date setting issue.
If I copy and paste into the same workbook but not a table(manually) the date format does not change.

Appreciate any advice!!

My work around for this is to change the format on the data once it has been pasted in. When I run the macro again next week it will beinteresting to see if this repeats, as I am not sure why it is doing thiw now when it hasn’t done this before.