Data refresh

  • Thread starter Thread starter Ludi
  • Start date Start date
L

Ludi

Hi, in Excel 2000, when you select to do a data refresh
either by opening the doc or by selecting data refresh,
is there a way you can protect the formattting style of
the data I have set-up, eg the font size & style, cell
size etc. I notice when I refresh it pastes it back
unformatted.
Thanks
 
Hi Ludi
I have found that the only way to overcome this problem is to record
macro that refreshes the data and then formats as I want it to appear.

I then link the macro to a button of the worksheet. - The 'bonus' i
that you get to refressh the data in one less mouse click
 
Back
Top