Look up "cross-reference" in Excel help for more detail and worked-out examples on how to do what you want. Either or both do a search in the Excel Help, or create an Index there by going to the Index tab and tabbing to and entering on the wizard, etc. if you haven't already created an index. You only need to do this once. (This is so as to bring up your required help quickly at any time thereafter.)
----- Original Message ----- From: "Williams, Robin" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 05, 2008 12:40 PM Subject: [JAWS-Users] Using cross-sheet references in Excel with Jaws Hi all, I need to use a cross-sheet reference in Excel for some work I am doing. I.e. I am in a worksheet, and need to use data from another worksheet (actually another workbook i.e. a separate file) in my formulae. Now according to the Jaws Help for Excel, under Miscelaneous hints, I can apparently press equals (=) in the cell in which I want to produce the formula, navigate to the appropriate place in the other file, select the relevant cells, etc, which sounds fine. However when I press equals, and go to open another file, pressing ctrl+o does nothing and indeed the open option is unavailable in the file menu. I have tried long and hard to solve this and have got nowhere, am I just making a simple mistake? How can I navigate to the file I need when entering a formula? I am using Jaws 9.0 with Excel2003. Many thanks for any help. Robin Williams Met Office summer intern - Health Forecasting [EMAIL PROTECTED] Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/[email protected] To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/managers.php If you wish to join the Blind Computing list send a blank email to the following address: [EMAIL PROTECTED] Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/[email protected] To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/managers.php If you wish to join the Blind Computing list send a blank email to the following address: [EMAIL PROTECTED]
