spurs
Active Member
- Joined
- Oct 18, 2006
- Messages
- 479
- Office Version
- 2016
- 2013
- 2010
- 2007
- 2003 or older
- Platform
- Windows
I have a worksheet filled with cells like this
=IF(isvisible('Calibration with IO'!G35),'Calibration with IO'!G35,Calibration!G35)
they were functioining but now they all show #value! unless i manually click on every cell and hit enter
why are these not updated automatically even though automatic workbook enabled is on
note that the worksheet Calibration with IO was not visible but making it visible does not change anything
whether its visible or not, i have to manually go into each cell and hit enter for it to update
Is this a change in syntax from previous excel versions?
Thoughts ?
=IF(isvisible('Calibration with IO'!G35),'Calibration with IO'!G35,Calibration!G35)
they were functioining but now they all show #value! unless i manually click on every cell and hit enter
why are these not updated automatically even though automatic workbook enabled is on
note that the worksheet Calibration with IO was not visible but making it visible does not change anything
whether its visible or not, i have to manually go into each cell and hit enter for it to update
Is this a change in syntax from previous excel versions?
Thoughts ?