Forum Discussion
How can I prevent an external reference from being created?
I have spent a few days trying to create a new spreadsheet that uses a lot of data from another spreadsheet. However I do not want to create any external references. I can't figure out when or why Ex...
Adsf-32 Click the cell with the formula you want to copy. In the formula bar, highlight the text of the formula. Ctrl+C. Esc to deselect the cell. Click the cell you want to put the formula in. Right click inside the formula bar and paste. It will copy the text as written without making XREFs.
You could also comment out the formula. Append an apostrophe before "=" in your formula and copy it over, then delete the apostrophe. No XREFs.
Time consuming, but see https://xkcd.com/2565/ to understand how this kind of "les buggeures risible" activity is critical to workplace flow.