Get external data-formats too

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

merge cells without losing data OR format 1
Pivot Table loses formatting after refresh? 0
Copy from Word to Excel, and retain indent, plus word wrap 1
Lookups - how to obtain data from a master spreadsheet into another 5
External Data Toolbar permanently greyed out. 7
How can I retain the formatting of the data in a lookup table? 1
Excel 2003 - Importing External Data - formatting problem? 2
protect cell format 1

Back
Top