Global Formulas
In Excel, how can I create a permanent global formula that can be revoked at any book? for example …?
From Occasionally I need time a cell "x", "Y" or "z". X, y and z are numbers that will not change and will be recalled that in most cabinets. Can I make a formula that works well … Recallx = (A1) that I can call when I need it?
Not sure if I understand your question. But if you has the values in a spreadsheet referred to other pages simply navigate to them when writing formulas. Say you have a folder called backup "reminder" that the constants in x, y, z in Open / create a new workbook and type in cell A1 = then click the tab "Recovery" and click the cell containing x, and press return. Now we will be back in the new book and the cell A1 is linked to another file. When you open the file you are asked to confirm the updates. If the removal is opened on the same PC at the time changes are instantaneous. You can not rename file "recovery" or not found. If you change x to recall "" This will change in the update when you open a new file.
My Global Formula
