Hi. I'm doing a bit of work for a bookkeeper. They have two spreadsheets, one referencing another. I would like to reference the 2nd spreadsheet using a constant variable containing the path of that 2nd spreadsheet rather than explicitly declare the path in every cell. That way the path can be updated en-masse.

Here's the original formula:
Please Login or Register  to view this content.
I hit CTRL-F3 and created a named constant pointing to a path string on a 2nd worksheet. The constant is called cc and the string looks like this:
Please Login or Register  to view this content.
I then adjusted the formula above by enterning cc in place of the first path:
Please Login or Register  to view this content.
The problem being, when I hit enter on that formula, Excel opens up the dialog box to pick the file. Any ideas anyone?

Thanks in advance,
Nick