Running Counta on Xls vs. xlsx

Hi All,

I am running 2010 and creating a report that gathers info from multiple spreadsheets across multiple network servers. These spreadsheets are saved in both xls. and xlsx formats as the users have various versions of excel.

My question is would I expect any impact to the results? I am mostly just using Counta.

The reason I am asking is that the result reported is much higher than expected on the first file that is xls. I'm not sure if this is a coincidence or if that there is some kind of compatibility issue.

****UPDATE - I saved the xls worksheet as xlsx. and the result becomes accurate so there must be a connection. Is there any way to resolve this as I will definitely need to pull from both file types.

Thanks for your thoughts,

Les

Thanks for replying. I think I figured out the issue. Just putting here for someone else if it helps.

Here was the formula I was using "=COUNTA('C:\CFI\[OttawaWork.xlsx]Sample Plan'!$AY$2:$AY$1048576)

This issue was that the total number of rows in excel 2003 is much less so I dropped it to a lower number (as I would never get that high anyway) and the result of this was successful:

"=COUNTA('C:\CFI\[OttawaWork.xlsx]Sample Plan'!$AY$2:$AY$60000)

This solved the problem.

Take care,

Les