Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I work with linked data in two workbooks , Everytime I input some new data
into the called data bank book , then the cell values change in the other book although is was linked . I went as far as to rename all the data cells with names and not with references as they use to , and crosslinked the names with the other cells on the other workbook , but still when I do a sort or insert on in my data bank , all the values of the linked cells change . Could any one please give me some advice as to lock the values of all the data in my data bank with the linked values ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
If I have X,Y data how do I sum the Y values using a set of bins based on x values | Excel Worksheet Functions |