It sounds like you do not have "auto updating" turned on in Excel setup.
Try this: Click the Office Button > Excel options (at bottom) > Formulas (left menu) > Under Calculation options > AutomaticLet me know if that works for you.
Already checked that and it was always set on automatic.
Also try this close all Excel applications and files, then start Excel 2007,
1- click the Office button2- click Excel Options button3- in the left pane click Trust Center4- click Trust Center Settings button5- in the left pane click Macro Settings 6- select "Enable all macros...".
Had that activated also
On the Calculation tab, the Update remote references check box is it checked..?
Let me open this Question for other Experts as I am out of Ideas
OK Thanks. I've been using Excel for 18 years now and this has me stumped.
I was asked to try to help you with this issue
First can you check the Status Bar at the bottom of the Excel window and make sure that the phrase "Circular Reference" is not showing there
Ok please check and fix ALL these settings
1) Office Button > Excel Options > Advanced, then under 'General' UNCHECK the box "Ignore other applications that use Dynamic Data Exchange (DDE)"
2) Office Button > Excel Options > Advanced, then under 'When calculating this workbook' CHECK the box "Update links to other documents"
3) Office Button > Excel Options > Trust Center > Trust Center Settings button > External Content tab, CHECK the box "Enable automatic update for the workbook..."
Hope this helps. If I was able to answer your Question please go ahead and RATE this answer "Excellent" or "Good" so I get credit for my work.
Ok no problem don't take my advice and don't pay for it, but why leave me a negative feedback (which will sit on my record) when I gave you that much of my time gratis
Hi, I’m a moderator for this topic and I wonder whether you’re still waiting for an answer. If you are, please let me know and I will do my best to find another Professional to assist you right away. If not, feel free to let me know and I will cancel this question for you. Thank you!
Sometimes, finding the right Professional can take a little longer than expected and we thank you greatly for your understanding. We’ll be in touch again shortly
The way the site works is that the only way to remove a rating is by overriding it by a better rating (it takes the higher of the two ratings)
Ok I need you to send me your both excel files.
Do you know how to zip therm together and upload them. If not, I will send you the instructions
Ok for each file:
go to http://www.wikisend.com/ and upload the file using the Browse button (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
You sent only the "Farrell acct.xlsx" file
Got them. Thanks
Now please clarify which formula (i.e in which cell, on which sheet, and in which file) is not updating
Which one is the 'dependent sheet'?
Just give me ONE example:
which formula (i.e in which cell, on which sheet, and in which file)
I will get back to you as soon as I have completed the review and/or solution
Had to step out for a while. I just got back and will start on it now...
Ok I want you to test these files per the instructions below
1- Download the zip file
2- Save it to your desktop
3- Create a new folder on your desktop
4- Extract the two files and save them in that new folder
5- Open the CABINET DATABASE file first
6- Then from within Excel open the second file (i.e. "Farrell acct 2.xlsx")
7- Go to the 'PRICING SHEET' sheet
8- Check the formulas in M219:M290 (green cells) and test it to see if they now update as they should
Let me know