…Chris’ ostensible rendezvous with reality

Excel 2007 woes – hidden rows and cell references

• January 15th, 2010
• Posted in Microsoft . Technology

So let’s say you’re working in Excel 2007. You’ve got a workbook with many worksheets inside, and you need to create a cell reference from one sheet to another. But what happens if you have hidden rows in the sheet you’re referencing from? Depends on how your options are set. One of the things I noticed [ READ MORE ]