LewBearGrills
New Member
Hi
I am trying to use find & replace to update some information currently held in certain cells in my spreadsheet. I have used F&R millions of times before and have never come across this issue, and when I look up what the Update Values: Par means I dont understand how it relates to what I am trying to do.
I have highlighted the cells in which the information is held. I have asked it to find what I am looking for (currently I am looking for all 'M') and then ask it to replace with 'P'
It then opens a window titled Update Values: Par and it looks like it is asking me to open a file (Ive selected a folder and its not asking me to save) but I dont know what file its asking me to open.
Its not a huge file or data selection I am asking for, probably only around 200 cells, though it still wont work when I try and make it smaller.
Ill probably sit bolt upright at 3am tomorrow when the answer pops into my head but I cant for the life of me find it right now
I am trying to use find & replace to update some information currently held in certain cells in my spreadsheet. I have used F&R millions of times before and have never come across this issue, and when I look up what the Update Values: Par means I dont understand how it relates to what I am trying to do.
I have highlighted the cells in which the information is held. I have asked it to find what I am looking for (currently I am looking for all 'M') and then ask it to replace with 'P'
It then opens a window titled Update Values: Par and it looks like it is asking me to open a file (Ive selected a folder and its not asking me to save) but I dont know what file its asking me to open.
Its not a huge file or data selection I am asking for, probably only around 200 cells, though it still wont work when I try and make it smaller.
Ill probably sit bolt upright at 3am tomorrow when the answer pops into my head but I cant for the life of me find it right now
