Get External Data
 

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?

Try resetting the used range on the worksheet, as described he

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

Then refresh the data.

EPratt wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html