Forum Discussion
tmlmyusername
May 07, 2021Copper Contributor
HELP! stuck excel cell formula I cant get rid of
Hi - I'm no excel guru - was doing a cut/paste of a few hundred rows of data, and somehow hit a wrong key(s), and now can't get rid of this weird formula I inadvertently created, which has my spreads...
tmlmyusername
May 07, 2021Copper Contributor
Hi Hans Vogelaar, thank you for reaching out. There is no sensitive data in the spreadsheet, so I hope these screenshots will suffice. First image is from the spreadsheet I was working on when things locked up. Second image shows the different circular reference in the formula bar of the 2nd spreadsheet
tmlmyusername
May 07, 2021Copper Contributor
Apologize if the image quality is fuzzy. To your request of sending a copy of the file - I am unable to do anything with either file. Almost all functions are disabled, including copy/paste. I can't even open another new excel spreadsheet. When I try to do any of these things I get "There is a problem with this formula" error message. I've tried putting an apostrophe in front of the formula as suggested to try & fix the formula, but that's as far as I can get. And I wasn't trying to create a formula at all. Just ended up with me mistakenly hitting 1 or more keys on the keyboard when I was trying to cut/paste
- tmlmyusernameMay 07, 2021Copper ContributorPretty much the only function available is scrolling up or down in the files. Any suggestions?
- tmlmyusernameMay 07, 2021Copper ContributorUnder Formula's tab, it appears I now have everything but "Calculations" features available
- tmlmyusernameMay 07, 2021Copper ContributorScratch that - just the "Function Library" features are available