Formatted query

[Guest]

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

 

[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