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"....
HansVogelaar Thanks for your reply!
You know what the problem is?
I defined the name, it went without error.. but, when I'm trying to select data from graph and type:
=TTT Sheet uno!Data it gives me the error above.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
- I did send you a private message.