| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Linking Source
I have a spreadsheet with numerous linked worksheets- in only one of the
worksheets, once I enter the data it updates it to my master document but it moves it up one cell, can someone help?? -- thank you TOS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Linking Source
Place the linking formula in the correct cell on the Master sheet?
Gord Dibben MS Excel MVP On Thu, 25 Sep 2008 06:10:01 -0700, TOS wrote: I have a spreadsheet with numerous linked worksheets- in only one of the worksheets, once I enter the data it updates it to my master document but it moves it up one cell, can someone help?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Linking Source
Thanks Gord, I've tried that, I can't figure it out, every other worksheet
has the same link and it works for them, this particular one, once I enter the data in the worksheet, I go to the master sheet and it has the correct data except it is in the cell directly above...it is the strangest thing... -- thank you TOS "Gord Dibben" wrote: Place the linking formula in the correct cell on the Master sheet? Gord Dibben MS Excel MVP On Thu, 25 Sep 2008 06:10:01 -0700, TOS wrote: I have a spreadsheet with numerous linked worksheets- in only one of the worksheets, once I enter the data it updates it to my master document but it moves it up one cell, can someone help?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Linking Source
For the sake of clarity it is always best to post actual cell references and
formulas. Locations like "above", "beside", "below" makes it hard to troubleshoot. e.g. in A10 you have =Sheet2!C10 The contents of Sheet2 C10 show up in A9 but not in A10 Do you have a formula in A9? Gord Dibben MS Excel MVP On Thu, 25 Sep 2008 09:02:01 -0700, TOS wrote: Thanks Gord, I've tried that, I can't figure it out, every other worksheet has the same link and it works for them, this particular one, once I enter the data in the worksheet, I go to the master sheet and it has the correct data except it is in the cell directly above...it is the strangest thing... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Cells -- Keep Source Cell's Formatting | Excel Discussion (Misc queries) | |||
| linking to external dbf data source | Excel Discussion (Misc queries) | |||
| Linking Axes Max & Mins to source chart | Charts and Charting in Excel | |||
| How do I copy & paste formulas without them linking to the source | Excel Discussion (Misc queries) | |||
| Linking One Source to Two Workbooks | Excel Worksheet Functions | |||
Linear Mode
