New Member
August 14, 2024
Appreciate any help.
Only on step 3 of the Personal Budget in Excel free download.
https://www.myonlinetraininghu.....excel#down
When I change the amounts - say Salary from 4000 to 3000 the little Green Triangle with YELLOW Warning Box shows up for each.
Can hit the IGNORE the Error, but I am afraid I am messing up something else.
This shows up on every change I make on this sheet in the Jan - Dec Columns.
Trying to add a screen shot.
Thank you
Ash
Moderators
January 31, 2022
The screenshot didn't come through. Save it to your computer first, then upload it as an attachment and press 'start upload', wait until it's finished. Then submit your reply. But even better to upload the file you are working with (similar process).
Tried to replicate the error, but didn't succeed. What does the 'error' message say?
VIP
Trusted Members
December 7, 2016
Hello,
In the blog post Personal Budget in Excel there is this note at the end of step 2.
Note: in earlier versions of Excel you cannot use the table's structured references in the 'Refers to' field. Instead see this post on Excel Tables as a Source for Data Validation Lists for a solution.
So, what version of Excel do you have?
Br,
Anders