Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cannot use formula to link to another sheet
Everytime I create a link in one sheet of excel to another sheet, it
overwrites the address with the sheet I am currently in (creating a circular reference most of the time)... I think it's either an excel bug (never had this before in 10 or so years of using excel) or a setting I've not seen before... help please |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cannot use formula to link to another sheet
Which version of Excel and how are you creating the link?
Typing the link in or pointing to the other sheet? What would be a typical formula that exhibits this behaviour? Gord Dibben MS Excel MVP On Tue, 14 Aug 2007 06:44:01 -0700, Robindotadams wrote: Everytime I create a link in one sheet of excel to another sheet, it overwrites the address with the sheet I am currently in (creating a circular reference most of the time)... I think it's either an excel bug (never had this before in 10 or so years of using excel) or a setting I've not seen before... help please |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cannot use formula to link to another sheet
Excel 2003
If I have 2 sheets, called "sheet1" and "sheet2". In Cell A1 of sheet1 I type "+" and then use the mouse to click on sheet2 tab and cell B1 then "enter", the formula appears in sheet 2 cell A1, not where I started it (Sheet1:A1). If I type the full formula in it works, but I can't "select a cell on a different sheet with the mouse" as it then moves the entire formula to that sheet!!! "Gord Dibben" wrote: Which version of Excel and how are you creating the link? Typing the link in or pointing to the other sheet? What would be a typical formula that exhibits this behaviour? Gord Dibben MS Excel MVP On Tue, 14 Aug 2007 06:44:01 -0700, Robindotadams wrote: Everytime I create a link in one sheet of excel to another sheet, it overwrites the address with the sheet I am currently in (creating a circular reference most of the time)... I think it's either an excel bug (never had this before in 10 or so years of using excel) or a setting I've not seen before... help please |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
cannot use formula to link to another sheet
=Sheet2!B1 manually entered in Sheet1!A1 works OK but when you type an = sign in
Sheet1A1 then point to Sheet2!B1 it does not. Sheet2!A1 receives the formula and Sheet1!A1 is blank? I cannot replicate this but perhaps another reader will have an idea. I tried changing Transition options to Lotus mode and still could not replicate. Gord On Tue, 14 Aug 2007 08:28:01 -0700, Robindotadams wrote: Excel 2003 If I have 2 sheets, called "sheet1" and "sheet2". In Cell A1 of sheet1 I type "+" and then use the mouse to click on sheet2 tab and cell B1 then "enter", the formula appears in sheet 2 cell A1, not where I started it (Sheet1:A1). If I type the full formula in it works, but I can't "select a cell on a different sheet with the mouse" as it then moves the entire formula to that sheet!!! "Gord Dibben" wrote: Which version of Excel and how are you creating the link? Typing the link in or pointing to the other sheet? What would be a typical formula that exhibits this behaviour? Gord Dibben MS Excel MVP On Tue, 14 Aug 2007 06:44:01 -0700, Robindotadams wrote: Everytime I create a link in one sheet of excel to another sheet, it overwrites the address with the sheet I am currently in (creating a circular reference most of the time)... I think it's either an excel bug (never had this before in 10 or so years of using excel) or a setting I've not seen before... help please |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
cannot use formula to link to another sheet
I couldn't duplicate it either.
But another option that may work for you until you determine the solution.... select the "sending" cell edit|copy select the "receiving" cell edit|paste special|paste link Robindotadams wrote: Excel 2003 If I have 2 sheets, called "sheet1" and "sheet2". In Cell A1 of sheet1 I type "+" and then use the mouse to click on sheet2 tab and cell B1 then "enter", the formula appears in sheet 2 cell A1, not where I started it (Sheet1:A1). If I type the full formula in it works, but I can't "select a cell on a different sheet with the mouse" as it then moves the entire formula to that sheet!!! "Gord Dibben" wrote: Which version of Excel and how are you creating the link? Typing the link in or pointing to the other sheet? What would be a typical formula that exhibits this behaviour? Gord Dibben MS Excel MVP On Tue, 14 Aug 2007 06:44:01 -0700, Robindotadams wrote: Everytime I create a link in one sheet of excel to another sheet, it overwrites the address with the sheet I am currently in (creating a circular reference most of the time)... I think it's either an excel bug (never had this before in 10 or so years of using excel) or a setting I've not seen before... help please -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link cells, sheet to sheet, to recognize row deletions? | Excel Discussion (Misc queries) | |||
???Replicate a sheet but chart still link to original sheet | Charts and Charting in Excel | |||
Link individual sheet to one sheet in another workbook | Excel Discussion (Misc queries) | |||
Excel how do I link text values in one sheet to another sheet? | Excel Discussion (Misc queries) | |||
trying link row on one sheet into column on another sheet | Excel Worksheet Functions |