Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text box link doesn't update
Hello,
I have a dynamic chart on it's own tab with a scroll bar to select the number of weeks in view at any given time. I added a text box that references the cell link for the scroll bar to display the value of the scroll bar (corresponds to the week number). The link works great as long as I'm in the file. When I close it and re-open, the text box no longer updates and the formula is not present in the bar. Can anyone advise what may be happening? Thanks in advance for your help. -Bruce |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text box link doesn't update
Hi,
I can't duplicate your problem. What version of Excel are you using? What does the formula look like on the formula bar? How did you create the text box? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "brumanchu" wrote: Hello, I have a dynamic chart on it's own tab with a scroll bar to select the number of weeks in view at any given time. I added a text box that references the cell link for the scroll bar to display the value of the scroll bar (corresponds to the week number). The link works great as long as I'm in the file. When I close it and re-open, the text box no longer updates and the formula is not present in the bar. Can anyone advise what may be happening? Thanks in advance for your help. -Bruce |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text box link doesn't update
Shane,
I'm using Excel 2003 SP3. I created the text box by selecting it from the drawing toolbar, then mousing it on the chart. I then clicked the in formula bar, typed the = sign and then selected the tab with the data source, clicked in the cell, and hit enter. I've re-created several ones and even a control label box all with the same result. it works well until I re-open the file, then it no longer updates. The file does have external data links, which I select the "Do not update" upon opening. Not sure if this impacts the operation of the text box (which is not linked to the external data). It is odd, I have other excel files with this function (albeit the text box is on the same sheet as the data source) and it still functions. Thanks for the help. -Bruce "Shane Devenshire" wrote: Hi, I can't duplicate your problem. What version of Excel are you using? What does the formula look like on the formula bar? How did you create the text box? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "brumanchu" wrote: Hello, I have a dynamic chart on it's own tab with a scroll bar to select the number of weeks in view at any given time. I added a text box that references the cell link for the scroll bar to display the value of the scroll bar (corresponds to the week number). The link works great as long as I'm in the file. When I close it and re-open, the text box no longer updates and the formula is not present in the bar. Can anyone advise what may be happening? Thanks in advance for your help. -Bruce |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text box link doesn't update
Also,
the formula in the formula bar is missing when I re-open, there is nothing there. -bruce "Shane Devenshire" wrote: Hi, I can't duplicate your problem. What version of Excel are you using? What does the formula look like on the formula bar? How did you create the text box? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "brumanchu" wrote: Hello, I have a dynamic chart on it's own tab with a scroll bar to select the number of weeks in view at any given time. I added a text box that references the cell link for the scroll bar to display the value of the scroll bar (corresponds to the week number). The link works great as long as I'm in the file. When I close it and re-open, the text box no longer updates and the formula is not present in the bar. Can anyone advise what may be happening? Thanks in advance for your help. -Bruce |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text box link doesn't update
To add a text box to a chart, it is best to begin by activating the chart
(by clicking on it). In this way the text box is aid to be grouped to the chart Then you can put the link in the box Try this and tell us what happens best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "brumanchu" wrote in message ... Hello, I have a dynamic chart on it's own tab with a scroll bar to select the number of weeks in view at any given time. I added a text box that references the cell link for the scroll bar to display the value of the scroll bar (corresponds to the week number). The link works great as long as I'm in the file. When I close it and re-open, the text box no longer updates and the formula is not present in the bar. Can anyone advise what may be happening? Thanks in advance for your help. -Bruce |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text box link doesn't update
Same result....
"Bernard Liengme" wrote: To add a text box to a chart, it is best to begin by activating the chart (by clicking on it). In this way the text box is aid to be grouped to the chart Then you can put the link in the box Try this and tell us what happens best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "brumanchu" wrote in message ... Hello, I have a dynamic chart on it's own tab with a scroll bar to select the number of weeks in view at any given time. I added a text box that references the cell link for the scroll bar to display the value of the scroll bar (corresponds to the week number). The link works great as long as I'm in the file. When I close it and re-open, the text box no longer updates and the formula is not present in the bar. Can anyone advise what may be happening? Thanks in advance for your help. -Bruce |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text box link doesn't update
I have uncovered the problem. I left out (forgot) the fact that the
reference cell was a named range. Once I referenced a page!column:row, the link works. It's always the little things... Thanks for your follow-up's though, there are great people in this community! -bruce "brumanchu" wrote: Same result.... "Bernard Liengme" wrote: To add a text box to a chart, it is best to begin by activating the chart (by clicking on it). In this way the text box is aid to be grouped to the chart Then you can put the link in the box Try this and tell us what happens best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "brumanchu" wrote in message ... Hello, I have a dynamic chart on it's own tab with a scroll bar to select the number of weeks in view at any given time. I added a text box that references the cell link for the scroll bar to display the value of the scroll bar (corresponds to the week number). The link works great as long as I'm in the file. When I close it and re-open, the text box no longer updates and the formula is not present in the bar. Can anyone advise what may be happening? Thanks in advance for your help. -Bruce |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text box link doesn't update
Then you are doing something wrong. I have I just added a text box with a
link to a cell, saved and reopen the file; the link is tell there Want to send me a sample file? Get my email from my website -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "brumanchu" wrote in message ... Same result.... "Bernard Liengme" wrote: To add a text box to a chart, it is best to begin by activating the chart (by clicking on it). In this way the text box is aid to be grouped to the chart Then you can put the link in the box Try this and tell us what happens best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "brumanchu" wrote in message ... Hello, I have a dynamic chart on it's own tab with a scroll bar to select the number of weeks in view at any given time. I added a text box that references the cell link for the scroll bar to display the value of the scroll bar (corresponds to the week number). The link works great as long as I'm in the file. When I close it and re-open, the text box no longer updates and the formula is not present in the bar. Can anyone advise what may be happening? Thanks in advance for your help. -Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update link value | Excel Worksheet Functions | |||
Don't update link | Excel Discussion (Misc queries) | |||
update link | Excel Worksheet Functions | |||
Update only 1 variable in a link | Links and Linking in Excel | |||
update a link to a CSV | Excel Discussion (Misc queries) |