ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2007 Solver Addin Error 400 (https://www.excelbanter.com/excel-programming/414393-excel-2007-solver-addin-error-400-a.html)

[email protected]

Excel 2007 Solver Addin Error 400
 
Hi
I'm wondering if anyone else has noticed the following : On loading MS
excel 2007, when I go to the data tab, I get a VBA prompt that reads
error 400. Apparently the solver add in is missing. So I go back,
trace the add in link, and presto it works fine. Now I close out
excel, reopen it, only to find the same problem all over again. Any
ideas what is going on here?

Thanks
Chet

[email protected]

Excel 2007 Solver Addin Error 400
 
On Jul 22, 7:53 pm, "Jim Rech" wrote:
Can't duplicate the problem here. Solver seems to load fine and I see it on
the Data tab, etc.

--
wrote in message

...

Hi
I'm wondering if anyone else has noticed the following : On loading MS
excel 2007, when I go to the data tab, I get a VBA prompt that reads
error 400. Apparently the solver add in is missing. So I go back,
trace the add in link, and presto it works fine. Now I close out
excel, reopen it, only to find the same problem all over again. Any
ideas what is going on here?


Thanks
Chet


Thanks for your time Jim. It is quite wierd.....I tried repairing MS
office...that did not work either. Also, I don't see the ADD INS tab
either....I wonder if its something to do with certain features being
disabled? Excel 07 is so different, I don't even know where to start
looking.
Thanks

Lauri

Excel 2007 Solver Addin Error 400
 
I have seen this error occur in two different scenarios. Sometimes (and
seemingly randomly) it occurs when i click on the data tab - i get the error
& no ribbon. I hit ok and then choose another tab - select the data tab - no
problem it works.

This is irritating but i just thought it would disappear when the patches
start coming out.

Now - i add-in solver. I have the solver button. I hit solver - i get the
error 400. No work around seems to open solver.

Anyone find a solution?

Lauri


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com