![](/uploads/1/2/6/7/126750746/509772627.jpg)
Have checked Activity Monitor and can't find Excel in there anywhere. Any suggestions? Running Mac OS Sierra 10.12.6. This thread is locked.
. Post titles to your problem. Provide in your post. Use the for non-questions. Only text posts are accepted; you can have images in Text posts.FAQ.Was your problem solved?OPs can (and should) reply to any solutions with:This will award the user a and change the post's flair to solved. To apply code formatting Use 4 spaces to start each lineYou can select code in your VBA window, press Tab, then copy and paste into your post or comment. Provide your dataInclude a or use the website to generate the reddit table markup from your spreadsheet.Congratulations and thank you to these contributors DateUserCP002580010A community since March 11, 2009 Download the official to convert Excel cells into a table that can be posted using reddit's.
I have a spreadsheet that I've been working on for work and spent hours adding information to the spreadsheet. I used the Developer tab to insert a text box and when I did, I received an error stating 'Reference isn't valid'. Now it's locked down my spreadsheet.
![Cannot Quit Microsoft Excel Cannot Quit Microsoft Excel](/uploads/1/2/6/7/126750746/628281106.png)
If I click on a cell, error populates. Click on another sheet, error populates. Click on the text box I added (left click and right click), error populates.I'm able to click on every tab across the top except for File. Every tab has everything grayed out except for Home which allows me to click Cut and Copy.
Cut doesn't change anything. I've attempted to type into the text bar to see if I can see data generating anywhere to figure out what's causing the issue but it just generates the error again.I thought maybe my spreadsheet got too large but looking at it before I made the changes, the file was only 526KB and I only added about 10% more onto the spreadsheet.I also attempted pressing F12 to save as a different file but it generates the same error.Please if anyone has any ideas, I'd really prefer to not redo hours and hours of work. I'm more than happy to try any ideas anyone has.
To make everyone aware in case this were to ever happen to another user, I just figured out how to fix this.Beside the text entry box I clicked 'Cancel'. When I did so, a formula popped up using '=EMBED'.
If I attempted deleting the EMBED formula, I continued getting the 'Reference isn't valid' error.If I clicked the Cancel button to show the EMBED formula, I was able to click on my of the buttons at the top again and Design Mode was selected. I clicked out of Design Mode and it fixed everything. When I went back into Design Mode to remove the text box, everything functioned properly. I was able to delete the text box and everything seems to be running smoothly.Not sure what happened here or why but I'll be marking this issue solved.
![](/uploads/1/2/6/7/126750746/509772627.jpg)