Forum Discussion
Excel absolute cell
Hi, I'm trying to lock the cell "4" so graph would retrieve data from that specific cell all the time! However, if add a row the formula in the series values is changing and "$A$4" becoming "$A$5"....
Yes, everything looks correct because it's not giving me the error.
However, it's reading the value but instead of actual number, is returning 0. What the problem might be??
However, it's reading the value but instead of actual number, is returning 0. What the problem might be??
I'm sorry, but I have no idea. As I have shown, it works correctly for me.
Does the workbook that I attached exhibit the problem for you?
- I see. That's sad.. Anyway, thank you for trying.
I see the problem. You did define the names correctly, so it's not your fault.
I have even tried another solution that does not involve the INDIRECT function It worked for the QQQ Holding series, but not for the WWW Holding series - exactly the same problem.
There is something very strange going on here. I don't know how to solve this, sorry.
I'm looking at it now.
- I've sent you a private message.
If possible, I'd like to see a copy of the 'real' workbook...
- Yes, in your workbook looks functional, thank you for that. When I try to set the formula in other excel document it gives me no value in return... Only one gives me the right value, the rest 0 ...
So the problem occurs in your workbook, but does it occur in the version that I attached (without modification)?
- Yes, I took it as an example and defined the name in my workbook but, from all of them just one work correctly, the rest return value 0. I have to mention that I have in graph around 12 data tables, don't know if this matter.