Forum Discussion
can't delete old solver data. can't save file where solver was reset.
Hi Walter,
Didn't test right now, what could work
- open old and new workbooks
- select ALL worksheets in first workbook (click on first sheet tab, press Shift, click on last tab)
- from right click Move and Copy, select copy, select second workbook from drop down menu and copy
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.
Thanks. This is my first time in this foum. Will my post remain "alive" until someone else sees it?
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?