I have just started putting access tables in excel. Pretty handy as not everyone at my work is familiar with Access. Problem I have is that when I refresh the data, the cell formatting reverts back to the Access formatting and not the Excel formatting I changed it to. Is there any way to keep the Excel formatting. I have looked this problem up and I believe I am doing what they say unless I am reading it wrong.
Thanks in advance.
David
Thanks in advance.
David