I started using Bronze two days ago. I think I have my data entered correctly on the home, income and expenses tabs. However, in tabular projection, the only correct columns are the income ones, specified expenses and taxes on income, and growth of savings. The cells in the other expenses columns, cash flow, withdrawals, and savings totals all have #VALUE! in them. Subsequent years have the same problem. I don't know if it is relevant but I'm working on a Mac with a M1 processor. Any advice is appreciated.
@janetgila77 If you would send me your file (to email@pralanaconsulting.com) I'd be happy to investigate this.
Thanks,
Stuart
Any resolution on this?
I'm running WIN11/Excel v 2505. My table values are formatted with strike throughs.
@mikemcd001 No, I haven't yet received the requested file; however, your problem is different and here's the explanation/fix: the strike-throughs are indicating that your data is stale even though it really isn't. The fix is to go to Excel's Formulas menu > Calculation Options and unclick the option for formatting stale values.
Stuart
Shouldn't the Calculations Options also be set to Automatic? I think the "Format Stale Values" option only works when in Partial or Manual mode.
@chrisb No, they should be set to partial, and that's where Pralana sets it. Reason: we do not want to run a Monte Carlo analysis every time a data entry field is modified.
Stuart
Hi Stuart,
I tried sending my data to you, but it bounced back. I'm not sure if you ever got it. Using the address email@pralanaconsulting.com, I get an error message that the address can't be found or is unable to receive mail.
Thank you for any help you can give,
Janet
