item price sorting

Never heard about a problem like this before bur googling I'v found this comment

The problem was not installing 'Visual Basic for Applications' before, when I installed Office 2007.
VBA is in Office Shared Features group.
Just insert your Office installation disk, select 'Add or Remove Features' and then VBA.
After that Solver can be installed in Excel.

Perhaps this may help you and then there is a link as well to a thread. In post #2 there is a reference to a hotfix (underlined) that will take you to a microsoft page explaining the hotfix where they say

This hotfix fixes the following issue: 957386
Error message after you set a network path as the default file location in Excel 2007 and then you click the Data tab: "\\<Path>\solver.xlam cannot be found. Check your spelling, or try a different path"

and in post #3 there is a description for fixing the problem your self (not for the faint of heart) by modefying the registry.

http://forums.techarena.in/windows-software/1377237.htm

Best of luck to you in fixing this problem.

Alf

ok ill try that

thanks for help