Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External Links using Excel
I am having a problem with an external link showing the path of the link
instead of the value. For example it shows ='[Sales Forecast.xlsx]January'!A2. When I first create the link it shows the value, but once I remove the absolute reference from the linked cell it shows the path. This is only happening with one of my workbooks that I link to. All the other workbooks I link to work just fine. How do I get this workbook to show the value instead of the path? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
External Links using Excel
Perhaps that cell is now formatted as Text - if so, change the format
to General (or one of the number formats), then double-click the cell as if to edit it and press Enter. This forces the format change to take effect. Hope this helps. Pete On Aug 30, 10:24 pm, JB25 wrote: I am having a problem with an external link showing the path of the link instead of the value. For example it shows ='[Sales Forecast.xlsx]January'!A2. When I first create the link it shows the value, but once I remove the absolute reference from the linked cell it shows the path. This is only happening with one of my workbooks that I link to. All the other workbooks I link to work just fine. How do I get this workbook to show the value instead of the path? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
External Links using Excel
Saved from a previous post.
Excel likes to help. Try this on a test worksheet. Select A1 and hit ctrl-; (to put the date in the cell) now select B1 and type: =a1 Notice that excel changed the format of B1 to match the format in A1. Now format D1 as Text. put ASDF in D1 put =D1 in E1 You see ASDF. With E1 selected, hit the F2 key and then enter (to pretend that you're changing the formula). Excel has "helped" you by changing that cell's format to text. I don't know of any way of changing this behavior. I just select the cell, and reformat it to General (or whatever I wanted). I hit F2 and then enter (to reenter that formula). Sometimes this feature is nice, sometimes it ain't. JB25 wrote: I am having a problem with an external link showing the path of the link instead of the value. For example it shows ='[Sales Forecast.xlsx]January'!A2. When I first create the link it shows the value, but once I remove the absolute reference from the linked cell it shows the path. This is only happening with one of my workbooks that I link to. All the other workbooks I link to work just fine. How do I get this workbook to show the value instead of the path? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Links in Excel 2007 | Excel Worksheet Functions | |||
Excel: Finding external "links" in a spreasheet | Excel Discussion (Misc queries) | |||
Excel 2003: Temporarily "turning off" links to external files... | Excel Discussion (Misc queries) | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
How do I remove external links from Excel 2000 workbook? | Excel Discussion (Misc queries) |