Software

Ask something
Discussion Locked

Excel cannot find the data

0 helpful
6 replies

by highlander718

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a worksheet with some 3000 records. The find utility is working fine only up to row 2222, after that even if the record is certainly there, I got a "Excel cannot find the data" message. And that foe any record below that point. I checked the format of the cells before and beyond that point, everything looks the same.
Any clues ?

6 replies

by kees.valkenswaard

What you have done I really do not know. I just made a sheet with 255 columns [the maximum] and 20000 rows [thinking that would be sufficient]. No problem in finding something on line 5000, 15000 and so on.
It could depend on your settings in the find, such as full cells, formulas or values, etc.
You could ZIP the file and mail it. I am curious to know what is going on.
When mailing put also Q&A in the subject field, else the message will be deleted.
Good luck

by highlander718

Unfortunately I can't send you the file. It's business related. Obviously a normal Excel file will not give any problems finding records I'm trying to find out what's wrong with this particular file. The problem is I'm not the owner of the file, and I have no idea what they could've done with it.

by highlander718

Unfortunately I can't send you the file. It's business related. Obviously a normal Excel file will not give any problems finding records I'm trying to find out what's wrong with this particular file. The problem is I'm not the owner of the file, and I have no idea what they could've done with it.

by joseph moore

Is your Excel spreadsheet pulling data in from an external data source, like over an ODBC connection to a remote database? If so, then I could imaging this happening.
If this is the case, then you need to scroll down the Excel page to get all of the records imported, then do a Find.
I don't think that all records are imported into Excel when you start the import. I think it only pulls in some of the records, and waits until you request more records farther down the page. At that time, the additional records are imported in.
If you do something like a Print or an Export, then all of the records are pulled in before printing or exporting.

hope this helps

by highlander718

Not really, but gave me a hint. Yes there were formulas instead of direct editing, starting with that exact cell.
Thanks,

This discussion is closed to new replies.