Hey I know there are a few computer literates around and whilst I don't consider Excel the be all and end all of statistical computation I've got a problem with somebody else's workbook. Basically there's a load of REF! errors and the person that created the book isn't around any more so I'm trying to find the thing it should be referencing, to be fair it's probably someone else fiddling with what was working but anyway.
The cell looks like this: =SUM('Week 3 Formulas'!B3:B151) Now I'd have thought Week 3 Formulas was another sheet but there doesn't seem to be one, is it possible to hide them from plain sight? Or can 'xxxx' reference something else? There are similar sheets with weeks 1 and 2 and they work fine (without there being a Week 1/2 Formulas sheet) so I tried tracing the precedents on the ones that work but the arrow points from an icon to the cell and I don't know what that means heh. It's no big deal or anything but any help gratefuly received as always. And whilst I'm here what's the ! operator?
The cell looks like this: =SUM('Week 3 Formulas'!B3:B151) Now I'd have thought Week 3 Formulas was another sheet but there doesn't seem to be one, is it possible to hide them from plain sight? Or can 'xxxx' reference something else? There are similar sheets with weeks 1 and 2 and they work fine (without there being a Week 1/2 Formulas sheet) so I tried tracing the precedents on the ones that work but the arrow points from an icon to the cell and I don't know what that means heh. It's no big deal or anything but any help gratefuly received as always. And whilst I'm here what's the ! operator?