Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Solver val error message

I have a spreadsheet with some pretty sophiscated financial and statistical
formulas but when I try to save it I get an error message saying "A formula
in a cell (Name:[Spreadsheet Name.xls]Worksheet Name!solver_val) could not be
converted because it contains a function that is not available in the file
format to which you are saving...

My question is how do I figure out which cell is the problem cell so I can
correct the problem? When I faced this problem in the past the precise cell
is given but this error message just says "solver_val" where the cell
location is usually found.

I don't think I ever used the Solver in this worksheet, although I'm certain
I've used it elsewhere in the workbook.

There is no error message or error value in any cell.

Any help is appreciated.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver Function - Making it Automatic JamesB Excel Worksheet Functions 9 April 3rd 23 01:21 PM
webquery and solver macros icestationzbra Excel Discussion (Misc queries) 2 February 23rd 06 06:47 PM
Solver does not work from Macros mjd918 Setting up and Configuration of Excel 1 January 6th 06 04:15 PM
Trouble with Solver Wanderingspirit99 Excel Discussion (Misc queries) 0 September 12th 05 03:50 PM
Using Solver with VBA EggShell Excel Discussion (Misc queries) 2 August 22nd 05 07:06 AM


All times are GMT +1. The time now is 06:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"