Get External Data

[Guest]

I've created several Excel workbooks that retrieve data from Lotus Notes
Views. Most work fine, but one of them gives me the following error when the
workbook is opened (with Refresh Data On File Open selected) - "The query
returned more data than will fit on a worksheet".
I'm only getting 65 records back instead of 77. Any ideas why?

 

[Debra Dalgleish]

Try resetting the used range on the worksheet, as described here:

http://www.contextures.com/xlfaqApp.html#Unused

Then refresh the data.