98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » References to other workbooks
References to other workbooks
Resolved · High Priority · Version 2007
Wed 3 Nov 2010, 08:06Delegate Mark said...
Mark has attended:
Excel Intermediate course
Excel Advanced course
References to other workbooks
Hi
I am trying to reduce the clunkiness of my workbooks by referring to data in an original workbook when constructing formulas (functions in fact) in a new workbook. But if I start a formula in the new workbook i.e. =if(then click on the relevant cell in the original workbook), it will not click on it.
Do I have to write it in in longhand or is there a way if being able to just click on the cell in the original workbook?
Thx
Fri 5 Nov 2010, 16:16Trainer Stephen said...
RE: references to other workbooks
Hi mark
Thank you for your question
This problem arises when you have the two files in different instances of Excel, i.e. you have the xcel application open twice. If you open both files in the same instnce of excel you should have no problems. Simply open the first file, ad from within that workbook opn the second
Hope this helps
Regards
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Checking if a calculation adheres to Order of PrecedenceWhen writing formulas you must make sure that results will be calculated as you intended. |
