Forum Discussion

Walter de Milly's avatar
Walter de Milly
Copper Contributor
Aug 10, 2017

can't delete old solver data. can't save file where solver was reset.

I work with workbooks having multiple tabs and about 200,000 cells, 90% of which have formulas.   I use the Solver addin for these workbooks   I've run into two bugs in Excel 365, 64 bit which is p...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 10, 2017

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

 

 

  • Walter de Milly's avatar
    Walter de Milly
    Copper Contributor
    Aug 10, 2017

    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

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Aug 10, 2017

      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 Milly's avatar
        Walter de Milly
        Copper Contributor
        Aug 10, 2017

        Thanks.  This is my first time in this foum. Will my post remain "alive" until someone else sees it?

Resources