Excel 2007 : Named ranges no longer function

This is starting to be a problem, a big problem.
I have about 157 or so Named ranges to cells in various worksheets. The original hyperlinks no longer take you to the cell instead they simply open a folder dialog window.
Removing the hyperlink and resetting does no good, same result.

All help is appreciated!

Amazing as it sounds, this has rsolved itself?
Last week the named ranges did not work, today they work.