further to: How do I force a recalculation of a spreadsheet

Question

Level 1

16 points

further to: How do I force a recalculation of a spreadsheet

The ability to share a spreadsheet that is meant to help convey complex info, in a safe uneditable format, but that requires recalcs to show variations (when random numbers are generated) is impossible with Numbers as it sits. I currently have various "recalc" cells clearly labeled for myself to reset simulations and avoid causing confusion, BUT come on Apple, how hard would it be to provide a button, link, icon, toolbar element to smoothly (like many Apple UIs) force a recalc?

I want to share a view-only version of a simulation created in a Numbers spreadsheet, but ooopsie, i cannot.

Why was this purposely left out?

Posted on Jan 28, 2024 6:30 AM

Reply

Answer 1

Badunit

Level 7

31,202 points

Feb 1, 2024 7:15 AM in response to drewcurry

I do not know what you were using in Excel, maybe a visual basic macro and a button to run it? Numbers has neither.

Put the checkbox in a table by itself. It can be a table that consists of only this one cell. Lock all the other tables and charts and shapes, leaving this one single-celled table unlocked. That will keep all your calculations and charts safe. It isn't 100% perfect because a user can still inadvertently move or delete the single-cell checkbox table but it is just as simple to put it back or recreate it. They can also still delete the entire sheet because it is not lockable but no one will be doing that by accident.

Reply

Answer 2

Yellowbox

Level 7

22,095 points

Jan 28, 2024 6:39 AM in response to drewcurry

Hi drewcurry,

Numbers will recalculate whenever there is a change in the document. Use a Tick Box to create a change:

Regards,

Ian.

Reply

Answer 3

Feb 1, 2024 7:07 AM in response to drewcurry

Drew,

You could do it by Locking your main Table and putting a Check Bx in a little auxiliary table.

Jerry

Reply

Answer 4

drewcurry Author

Level 1

16 points

Feb 1, 2024 6:28 AM in response to Yellowbox

Thank you kindly, Ian.. that was appreciated and may help others, but in my case, referring to:

"I want to share a view-only version of a simulation created in a Numbers spreadsheet, but ooopsie, i cannot."

... i want to thwart the ability to alter the sheet itself, but still force a recalc, something that could be done with Excel (back in the day that i used Windows ;) )..

Reply

further to: How do I force a recalculation of a spreadsheet

Similar questions