Phoenix - Your AI AssistantExcel Fix - Circular Reference
- Posted:
- Proposals: 23
- Remote
- #1812274
- Expired
Sutton 
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
General information for the business: We do counseling and psychiatry.
Industry: Healthcare
Description of excel work: Excel Fix - Circular Reference that appeared suddenly, and I cannot get rid of it.
Extra notes: It's basically a spreadsheet to calculate the pay for our counselors.
PAYROLL! has the list of the counselors.
DATA! has the items that they're getting paid for.
if you go to DATA! Cell M10 (i highlighted it for you)... if you put dates 10/29 and earlier... save the file.. saves with no problem.
but if you put dates 10/30 and beyond... save the file... then Circular Reference comes in.
FYI - I tried to "Enable Calculations" under Options, but it takes FOREVER to save the file.
Industry: Healthcare
Description of excel work: Excel Fix - Circular Reference that appeared suddenly, and I cannot get rid of it.
Extra notes: It's basically a spreadsheet to calculate the pay for our counselors.
PAYROLL! has the list of the counselors.
DATA! has the items that they're getting paid for.
if you go to DATA! Cell M10 (i highlighted it for you)... if you put dates 10/29 and earlier... save the file.. saves with no problem.
but if you put dates 10/30 and beyond... save the file... then Circular Reference comes in.
FYI - I tried to "Enable Calculations" under Options, but it takes FOREVER to save the file.
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Max - can you share the spreadsheet? It\ll make quoting easier. Tx.
-
Hi Max
Could you attach the spreadsheet. Also whats special about the 30 October apart from being a Monday.
Thanks
Dave -
Hi Max,
I would need to see the file to judge the complexity of the problem before providing a proposal.
You can attach the file in reply to this message.
v/r
Tony H