| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External Data | Excel Discussion (Misc queries) | |||
| import external data from changing file name | Excel Worksheet Functions | |||
| Excel 97/2000 - Help with looking up external data. | Excel Discussion (Misc queries) | |||
| Glue/Lock cells to external data before refresh | Excel Discussion (Misc queries) | |||
| How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
Linear Mode
