Formatted query

B

Boris Å avc

I've done one query connection with ODBC in Excel. Then I formatted the page
in Excel. Can I do a refresh of data in Excel without losing formatting (i
change position of cells and stuff...)? And how?

Thanks for helping,
Boris Savc
 
D

Debra Dalgleish

Select a cell in the table
Choose Data>Import External Data>Data Range Properties
Add a check mark to 'Preserve cell formatting'
Remove the check mark from 'Adjust column width'
Click OK
 
Top