I have a multi-page workbook, and am using check boxes that - when checked - update a dollar amount. The formulas I have used work fine, until I zoom the page, then the check box farthest to the right stops updating when checked or unchecked.
It is a multi-step formula:
check box (in column J), to the cell the box is linked to, to a hidden sum box (in column A), to grand total sum (located at the top of the spreadsheet in a merged cell A-J).
The formula always updates in the sum box (A), but stops updating in the total sum when the page is zoomed so columns A-C don't show.
Any ideas? This is going to be used by consumers, and needs to function properly at all times.
Bookmarks