Hi,
I have created a dynamic chart and continously get an invalid reference message. I am assuming that this error message is triggered due to the dynamic chart.
Please provide recommendations on how we can disable or prevent this popup message.
Thanks,
Anthony
Anthony, could you please upload your working file? Please remove any confidential info.
Click on the star if you think I helped you
Look at your Dynamic Ranges.
I assume you have used OFFSET+COUNTA.
Do they point to the right cell,do they have the right offset height/width?
All references must have absolute cell ranges -so $ sign before letter and number
example $A$1.
A$1 or A1 could cause the problem
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks