Can you upload a copy of the spreadsheet here so I can look at it? Or use the link below for a secure upload to a place that only I can view the spreadsheet, and I will delete it when we're done.
Spreadsheet Secure Upload
If you upload, you'll have to let me know you when it's there.
So can you give me an example of the problem you're having. When I open the spreadsheet, BTW, it tells me there are circular references in your formulas.
You know that sometimes the LD by Fund is pulling from LD by Staff List 8-5-16 and sometimes it's pulling from LD by Staff 9-6-16
It works for me. If you change cell D6 in LD by Staff List 9-6-16, it updates in cell C10 on the LD by Fund tab.
I think the problem is that some of the formulas are referencing LD by Staff 8-5-16
Are you still there?
Do you know why it sometimes pulls from 9-6-16 and sometimes from 8-5-16? The LD by Salary is the same way.
So you changed Cell D6 on LD by Staff List 9-6-16 and the LD by Fund 9-6-16 did not change in cell C10? What's the value in C10?
Ok, to to the LD by Fund 9-6-16 tab, click Formulas from the menu and then click Show Formulas on the ribbon bar.
Then select Calculation Options from the ribbon bar and tell me what it's set to.
What is the calculation options setting?
Ok that's your problem. Change it to Automatic and things will calculate. If you want to leave it on Manual, press F9 for the cells to update.
If I've answered your question and resolved your issue, can you please accept the answer and rate me accordingly? I don't get paid anything for helping you unless you accept the answer. If not, please chat me back and I'll get you the information you need to resolve your issue. Thanks and have a great day!
Click the button again to go back to the data
The formulas will automatically copy when you duplicate a tab.
I don't know why it would be set to manual. Choose Calculate Now from the ribbon bar and see if it changes.
Yes, can you not see my responses?
We might if it's not changing for you, because it works fine on my end with the spreadsheet you uploaded to me.
The Show Formulas button. It's in yellow when selected and is showing the formulas. Click it a second time to show the data (that's a response to your "What button?" question)
No, it's a setting for the entire sheet. But you might need to change it individually on each sheet.
Thank you.Please don't forget to accept the answer. Have a great day!
Hi there. Just a reminder. Can you please accept the answer to the question or I don't get paid anything for helping you. Thanks!