View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Is it possible to link a whole table into another worksheet

2007 DataFrom Web

But formatting will not be captured, I'm sorry to say.


Gord

On Thu, 29 Oct 2009 07:37:02 -0700, ishah
wrote:

I was not able to find 'Import External Data Import Data. I am working with
office 2007 and I think you might be talking in 2003 version.

IF, I could find a way to do it as you describe below in office 2007, would
this also capture all the formatting? I have figured out how to make every
cell change when edited, but it does not adapt the original sheet's
formatting which is critical in this project. I have various headings in
larger print and bolded as well as some cells that have a hierachy (by
indenting within the same cell. i.e. xxxxxx

xxxxx

Is there any way to capture all this formatting as well as just the data?