This will give you version 15.39, which I think fixes all known problems with solver. If you want to test the very very latest update, when you launch AutoUpdate choose to join the Insider program, and then choose Insider Fast. Let AutoUpdate check for and install updates Go to the Help menu and choose Check for Updatesĥ.
Make sure your Mac has a working internet connectionĤ. To get Mac OS updates, go to the App store on your dock, and then click the Updates button to reveal available updates.ģ. Install Mac OS X updates followed by Office updates. Make sure your Mac has a working internet connection before checking for updates. Microsoft has been fixing solver in recent updates. One thing that is absolutely essential regarding Solver is that you have the latest version of Excel.
#Excel for mac crash conditional formatting how to#
I have no idea of what may have caused the problem, except that it followed a Solver malfunction (I think to remember that after having used Solver normally, clicking Tools/Solver to start it again nothing happened, clicked again and Excel crashed)Īny hint about how to prevent this from happening? This de-formatting problem already happened to me some time ago, but at the time it involved a single worksheet, now it happened with an entire workbook with a dozen of worksheets (16MB)! I am now little by little trying to reformat the more important fields I tried to copy the formatting from a previous file but for some reason also some calculation changed and I had to give up everything in black figures/text on blank background) - only survived formatting was the conditional one Was indeed "repaired" and opened but with all "static" formatting info gone (i.e. Recently after attempting to start Solver Excel behaved unusually (see later) - reopening the workbook I got an error message something like "file unreadable, do you want to repair it?" after a copule of different attempts I answered yes and the workbook
0 kommentar(er)
