Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
References to external workbooks in excel
99.9% of the time when I'm referencing a cell in another workbook, I want to
use a relative reference (e.g. C7) rather than an absolute reference (e.g. $C$7). Is there any way to change the default in excel that uses absolute references when refering to cells in another file? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
References to external workbooks in excel
I suppose you could use a macro but it would probably
be easier to hit F4 to cycle through the different combinations at the location bar. http://www.mvps.org/dmcritchie/excel/shortx2k.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Fightin Engineer" <Fightin wrote in message ... 99.9% of the time when I'm referencing a cell in another workbook, I want to use a relative reference (e.g. C7) rather than an absolute reference (e.g. $C$7). Is there any way to change the default in excel that uses absolute references when refering to cells in another file? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
References to external workbooks in excel
Bummer. That's what I've been doing, but it slows me down significantly. I
was hoping it was a feature that could be turned off like when excel automatically generates the "get pivot data" formula when you reference a cell in a pivot table. "David McRitchie" wrote: I suppose you could use a macro but it would probably be easier to hit F4 to cycle through the different combinations at the location bar. http://www.mvps.org/dmcritchie/excel/shortx2k.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Fightin Engineer" <Fightin wrote in message ... 99.9% of the time when I'm referencing a cell in another workbook, I want to use a relative reference (e.g. C7) rather than an absolute reference (e.g. $C$7). Is there any way to change the default in excel that uses absolute references when refering to cells in another file? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing excel workbooks Between Excel 97 and Excel 2003 | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |