Cannot use formula

[jwong]

When I export an excel spreadsheet from SQL reporting services, found out
that I cannot use formula in the spreadsheet...such as =sum(A1:A10) and
cannot perform sorting.

 

[Anne Troy]

Likely, you need "the fix".
See "Data Isn't Recognized..."
http://www.officearticles.com/excel/data_cleanup_tips_for_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

 

[jwong]

Hi Anne,

I tried but it isn't working. Thanks anyway.

Jeffrey