Computing desk | ||
---|---|---|
< August 6 | << Jul | August | Sep >> | Current desk > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
Hi,
I have a workbook A.xlsx which draws data from B.xlsx (the reason it does this is unimportant but it is a necessary fact for my application).
The part of A which draws from B has the following basic structure:
Week 1 | Week 2 | (...) | |
Bob | 20% | 25% | (...) |
Jane | 60% | 40% | (...) |
A VLOOKUP formula is used to obtain the percentage values corresponding to each date from B (using a hardcoded address - e.g. C:\folder\B.xlsx). The problem I am having is each week I need to "drag" the formulas to get the latest figures and when I do this Excel pops up a prompt asking me to relocate B.xlsx. This doesn't take a great deal of time but it is annoying and I really don't see what it is necessary given I have hardcoded the address of B.
Does anyone know how I can prevent this dialog box from popping up?
THanks! — Preceding unsigned comment added by 168.252.96.5 ( talk) 00:24, 7 August 2015 (UTC)
I am using Windows 7 laptop computer.The screen got rotated 90 deg.ante clockwise. How can I turn it normal way. Thank you. 175.157.26.227 ( talk) 02:15, 7 August 2015 (UTC)
If I have one or more documents open in Word but minimised, and I click on a new document in Windows Explorer to open it, the application insists on displaying the previous document too. Is there any way to stop it from doing so?
Windows 7, MS Word 2007.
Thanks,
Rojomoke (
talk) 15:24, 7 August 2015 (UTC)
Computing desk | ||
---|---|---|
< August 6 | << Jul | August | Sep >> | Current desk > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
Hi,
I have a workbook A.xlsx which draws data from B.xlsx (the reason it does this is unimportant but it is a necessary fact for my application).
The part of A which draws from B has the following basic structure:
Week 1 | Week 2 | (...) | |
Bob | 20% | 25% | (...) |
Jane | 60% | 40% | (...) |
A VLOOKUP formula is used to obtain the percentage values corresponding to each date from B (using a hardcoded address - e.g. C:\folder\B.xlsx). The problem I am having is each week I need to "drag" the formulas to get the latest figures and when I do this Excel pops up a prompt asking me to relocate B.xlsx. This doesn't take a great deal of time but it is annoying and I really don't see what it is necessary given I have hardcoded the address of B.
Does anyone know how I can prevent this dialog box from popping up?
THanks! — Preceding unsigned comment added by 168.252.96.5 ( talk) 00:24, 7 August 2015 (UTC)
I am using Windows 7 laptop computer.The screen got rotated 90 deg.ante clockwise. How can I turn it normal way. Thank you. 175.157.26.227 ( talk) 02:15, 7 August 2015 (UTC)
If I have one or more documents open in Word but minimised, and I click on a new document in Windows Explorer to open it, the application insists on displaying the previous document too. Is there any way to stop it from doing so?
Windows 7, MS Word 2007.
Thanks,
Rojomoke (
talk) 15:24, 7 August 2015 (UTC)