My formulas in Sheet1 are linked to Sheet2. Sheet2 is updated from MS Access table. When i refresh sheet2, the formulas change on sheet1. I do not want this to happen. I tried absolute and it still changes.
My formulas in Sheet1 are linked to Sheet2. Sheet2 is updated from MS Access table. When i refresh sheet2, the formulas change on sheet1. I do not want this to happen. I tried absolute and it still changes.
How exactly are you updating Sheet2 from MS Access? If anything you are doing is deleting or inserting rows, this will affect the formulas on Sheet1, even if you use absolute references.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks