Updating two cells linked in excel
Updating two cells linked in excel - adating ruhome
I want the cells to mirror each other so that whenever I choose a new value in either sheet 1 or sheet 2, the value on the other sheet is updated to match the newly selected value. Private Sub Worksheet_Change(By Val Target As Range) Dim r1 As Range, r2 As Range Set r1 = Range("C3") Set r2 = Sheets("Live Forecast Tool"). Range("C3") If Intersect(Target, r1) Is Nothing Then Exit Sub Application.
If you have a range of values that people are required to enter repeatedly, it’s best to create a dropdown list so that no invalid data can be entered.
I changed the setting as indicated above; but the auto-recalculate still did not work, and upon rechecking the "Calculation" option, found it had reset itself back to "Manual" all by itself.
Three attempts later and it was still adamant it wanted to be "Manual" and nothing else.
The only way to retrieve data is either for Workbook A to be saved without links, or for the 2013 user to open the source Workbook Z file.
Due to the way of working/file sharing in our office, this is an untenable way of working.
Example: Worbook A was created in Excel 2010 and contains external links to Workbook Z.
Users on 2010 version, can open Workbook A and see data results from links.I stripped the quotes and the cells calculated as normal.In my instance I was using a particular add-in called PI Datalink.I opened this spreadsheet, checked that this was still working and autoupdating with current installation of MS Excel and any new automatic office updates (which it did work with), and then just reopened the original spreadsheet. I ran into an issue where some cells weren't calculating.I checked all the normal things, like cell type, auto calculation, etc...Copy the contents of the spreadsheet to a new one, and deleted the old one (it wasn't a particularly important spreadsheet, thankfully), and everything was fine.