Hopefully a fairly simple question. How do I access formulae in my personal.xlsb from another worksheet without having to prefix the formula in the cell with personal.xlsb! ? I am using Excel 2007.
Ideally the formulae in this sheet should appear in the autocomplete list when I start typing formulae.