Auto format causes very large .xls files and slows my application.

[tur13o]

I don't know how many rows of data will be entered at runtime. Presently I
guess the maximum and apply auto format conditions to all rows that "could"
be used.



But this is creating very large .xls files (35MB) and is very inefficient
since every cell format is reassessed every time the workbook is modified
(can't switch off auto calc since users will forget to calc ! it's ok for me
but not them.).



Without using VBA, is there a way to apply auto format to rows containing
data ?

 

[Earl Kiosterud]

Select the range, then use Format - Autoformat.