Forum Discussion
can't delete old solver data. can't save file where solver was reset.
Thanks, but this led to another problem.
I first tried your suggestion, but the Solver issue reappeared in the new workbook.
So I decided to "reset all" in Solver before copying the sheet to a fresh book. When I tried that, I was presented with a new error message "Cannot do this command in Group Edit Mode."
I googled a bit trying to find a simple fix but the articles I pulled up had more to to with setting up group mode than removing it.
so... what next? Thanks
Walter, sorry, but i never worked with Solver, can't help with fixing of it.
Just in case, some ago i had an issue with "file can't be saved", fixed that by switching off Autosave option. That's not your case, but who knows.
- Walter de MillyAug 10, 2017Copper Contributor
Thanks. This is my first time in this foum. Will my post remain "alive" until someone else sees it?
- SergeiBaklanAug 10, 2017Diamond Contributor
Walter,
Yes, it always will be here. Another story if nobody answers in few days there are low chances it'll be answered at all.
Group Edit mode - that means few or all of your sheets are selected. I guess Solver shall not to work in such mode by design. By the way, i forgot there is Select All / Ungroup in right click menu for sheets tabs. Ungroup them before doing something with Solver.
And one point more - did you try to disable Solver Add-in in Excel Options?
- Walter de MillyAug 11, 2017Copper Contributor
Yes, thanks, I did try removing solver and rebooting but that didn't work.
I'm posting in other forums for help and working on other ideas...