| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
absolute cells when linking to an external file
Is there a way I can force the formulas not to be absolute when the formula
involves linking to an external file. That is instead of the formula coming back as =[Book1]Sheet1!$A$1, it will be =[Book1]Sheet1!A1 (without the dollar signs). This will help me make the linking faster. I'm looking at other options other than the find and replce. Thanks a lot, del |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
absolute cells when linking to an external file
del,
When you select your cell in the external file, press F4 immediately to cycle through your $ options.... HTH, Bernie MS Excel MVP "del" wrote in message ... Is there a way I can force the formulas not to be absolute when the formula involves linking to an external file. That is instead of the formula coming back as =[Book1]Sheet1!$A$1, it will be =[Book1]Sheet1!A1 (without the dollar signs). This will help me make the linking faster. I'm looking at other options other than the find and replce. Thanks a lot, del |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
absolute cells when linking to an external file
Oh gosh, you are so smart. Thanks for your help!!!
"Bernie Deitrick" wrote: del, When you select your cell in the external file, press F4 immediately to cycle through your $ options.... HTH, Bernie MS Excel MVP "del" wrote in message ... Is there a way I can force the formulas not to be absolute when the formula involves linking to an external file. That is instead of the formula coming back as =[Book1]Sheet1!$A$1, it will be =[Book1]Sheet1!A1 (without the dollar signs). This will help me make the linking faster. I'm looking at other options other than the find and replce. Thanks a lot, del |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting text from external file into cells. | Excel Discussion (Misc queries) | |||
| Linking Cells to a file that changes names | Excel Discussion (Misc queries) | |||
| Linking contents of multiple cells to an external object | Excel Discussion (Misc queries) | |||
| XP linking to external cells bug? | New Users to Excel | |||
| Linking sumif from external database file | Setting up and Configuration of Excel | |||
Linear Mode
