I suddenly have a wierd problem in one of my excel workbooks:

If for instance i am working 'far to the right' in a sheet (say in colomn AC, row4), and wants to link values from cells outside the current view (by typing =, and moving the mouse to for instance B2 (mouse-click), and then pushing enter to conform the formula = b2) -

The excel does not view the active cell AC5 in the area i am working, but rather the area around B4 instead....

This is workbook specific, and does not happen with new or other worksheets.

Hope someone has experience the same, as I spent 6 months building this model, and would not be happy to do it again only because this wierd thing happen...

rgds