Hi

I have a cell b1 with a formula entered in which is =sheet1!a1 but when I exit the cell it is not updating to the Sheet 1 A1 value but instead showing me the formula. it does seem to work if I enter in the formula into a different cell.

Any Ideas?

I also have a macro which creates a report from various source and outputs one sheet with all the figures. It works perfectly except I would prefer it to not jump from one screen to the next while it is producing the report any ideas on how to just stay on a sheet and have a msgbox say that the report is finished?