Wikipedia:Reference desk/Archives/Computing/2015 August 7

= August 7 =

Excel help
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:

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 tried to replicate this, but wasn't able to. I'm using Excel 2007 and adding the extra column and dragging the formula over just filled it in properly (well, once I fiddled with lookup portion, but there was no prompt of any kind, regardless of whether the other book was open or not). What version are you on? 64.235.97.146 (talk) 16:58, 7 August 2015 (UTC)

SCREEN ROTATION
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)


 * Go into Control Panel + Display. From there it can vary a bit by graphics card, but typically there is an "Advanced" button under Adjust Screen Resolution that has the rotation options. StuRat (talk) 03:33, 7 August 2015 (UTC)


 * Try Ctrl + Alt + arrow right. Or maybe it's arrow up. Otherwise try it with the Windows key instead of alt.


 * Pressing those keys is what probably caused the problem at the first place.--3dcaddy (talk) 04:44, 7 August 2015 (UTC)

Opening Documents in MS Word
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)
 * Disable tab grouping Erunaquest (talk) 23:13, 7 August 2015 (UTC)
 * Could you expand on that Erunaquest? The only reference to "tab grouping" I can find is about Firefox.  I don't think the concept of tabbed documents exists in Word.  Rojomoke (talk) 09:34, 8 August 2015 (UTC)
 * Sorry, I meant taskbar grouping. That might stop it, forcing each window to be a separate taskbar tab if you are currently using grouping. I found a microsoft page on your problem with maybe some answers as well. Erunaquest (talk) 10:25, 8 August 2015 (UTC)