I have an external link to an excel file that contains a table. I am able to
import the data but am not able to keep the source formatting. Is there a
way to do this?

I tried using "format painter" and just copying from the source file to the
new file. It works initially, however, when i refresh the data the
formatting gets all thrown off.

Any suggestions and/or other options to try would be appreciated.

Thanks,