View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
lyngwin lyngwin is offline
external usenet poster
 
Posts: 2
Default Linked spreadsheet is not automatically adjusting row height?



"Gord Dibben" wrote:

You don't.

It must be copied over separately.

Linking formulas can only return values, not formatting.


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 12:59:01 -0800, lyngwin
wrote:

The linked cells are not carrying the row height auto fit format from the
source sheet. How do I carry that format to the linked sheet?


If the source spreadsheet and the destination spreadsheet are both formatted to auto fit the row height, why is it notadjusting on the destination spreadsheet when the data is entered? Or how do I do this so it will auto adjust?