In Excel the Formula bar behaves differently in different bachines

V

vijay

Here is a problem which occurs on one machine and does not appear in another
machine, though the machines are identical in all aspects, the make memory,
software etc..

Question -
In excel in a cell if there is a formula with references using a function
(example sum or average) to four different cells in four different workbooks,
then the entire path of the workbook in which the cell is pointing to is
displayed in the formula bar, provided the referred workbooks are not opened.

Now if the refered workbooks are opened, and pointing to that cell having
the formula, then the formula bar does not display the entire path rather
shows only the minimal required reference.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In excel the formula bar behaves differently on different machines 0
Formulas do not link to other workbooks 4
same formula and cells for different worksheets 1
Formula appearing as Value in Formula Bar 1
Why do charts disappear? 3
summarizing data from various workbooks 4
Excel 2003 dynamic named range for the values in a pie chart 1
Excel ignore formula 8

Top