The best way I have found is to monitor cell changes. The following Sub would be placed on the sheet you are working with or want to monitor. The functions can be placed in a module. I generally will read data into a sheet that I can hide and pull values from there, that way you are not running a query each time something is entered. You can read from that sheet each time you want to return a value.
Google Spreadsheet won't display 'SUM' outcome in the cell Showing 1-11 of 11 messages. Google Spreadsheet won't display 'SUM' outcome in the cell. However, whenever I enter in for the cell '=sum(range),' not summation of the values is displayed. It is simply an empty white cell. When I go to 'View' and check 'All formulas,' the.
Welcome to the forums. So when you say they are hidden you see the rows are numbered 1,2,3,7,8,9. Or something like that where it skips a bunch? There is no chance someone deleted them?
![Excel spreadsheet not displaying data Excel spreadsheet not displaying data](/uploads/1/2/5/4/125447073/897827890.jpg)
If so there is a possibility that they are simply very small and not completely hidden. In this case highligh the concerned rows (or the rows surrounding the hidden rows) Then go Format - Row - Height and type 15 and enter. This should take care of the problem in either case if they're hidden or just very small. Squirt, Is your worksheet filtered? (I know that's sort of obvious, but if it is, my suggestion wouldn't be useful at all).
Filtering will hide rows that remain hidden when choosing Unhide Rows, because the filter is still applied. To turn off filtering, select the Data menu, then select Filter, and see if either autofilter or advanced filter has a check-mark by it.
If so, un-check it, and your rows should return. If that's not the solution. Assuming that the worksheet isn't filtered, try selecting all of the rows&columns with data, extending past the missing cells, and paste into a new worksheet.
You should at least be able to see what's there and what's not there, and may be able to re-construct the original sheet. Hope that helps, Cindy.