Get external data-formats too

D

Deeds

I have a file that gets data from another Excel spreadsheet. I want to have it retain the formatting (ie. indents) that were made on the imported file. Each time I refresh now, it left justifies everything...any ideas
Thanks
 
J

jeff

Hi,

If your sheet just gets its data with '=Sheet1!A12'-style
formulas, I don't think there's any way short of a macro
reformatting the data like the old.

Obviously, you can manually copy and paste special to
get most of what you want, but it didn't sound like
that's your situation...

jeff
-----Original Message-----
I have a file that gets data from another Excel
Click to expand...
spreadsheet. I want to have it retain the formatting
(ie. indents) that were made on the imported file. Each
time I refresh now, it left justifies everything...any
ideas?
 
Top