Updating two cells linked in excel
I stripped the quotes and the cells calculated as normal.In my instance I was using a particular add-in called PI Datalink.I also have had this problem with a very large spreadsheet that just stopped updating itself over the weekend, but having checked the above solutions, setting were already set to automatic, and sheet is too big to rebuild, so I was at a loss.
There are some web references to issues with Pivot Table links not updating in relation to 2013 upgrade and the only answers seem to be 'save without links' or 'open source file'. users must be able to view without having to open source file and simply editing links out is not a workable option.
That’s all great, but what if you need a linked dropdown list? For example, someone chooses a value in dropdown list A and you want the values to be updated in dropdown list B.
Let’s start with an example to better understand how we can use linked lists in Excel.
Let’s say I have a table that has three columns that represent the brands of a car: Toyota, Honda and Nissan.
The rows represent the models: So what we could do is have one dropdown that contained the brands, such as Toyota, Honda and Nissan and the second dropdown would have the models.
Search for updating two cells linked in excel:
Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.