Support Board
Date/Time: Sun, 11 May 2025 12:39:06 +0000
Post From: New Spreasheets
| [2014-10-28 19:23:27] |
| User14209 - Posts: 6 |
|
I am having difficulties moving from old spreadsheets to new spreadsheets. In the new spreadsheets, on sheet1 there is a reference to sheet5 in one cell. When Sierra is running the formula works. When I close Sierra and open it again, in sheet1 I loose the reference in the formula for sheet5. What I am doing wrong ? PS In one cell of sheet1 the formula reads :=if(row($a3)=3,sheet5!$c$3-Sheet5!$d$3,0) When I close and open Sierra Ithe cell reads : =if(row($a3)=3,#ref!!$c$3-#ref!!$d$3,0) |