How to Properly Copy Formulas to Another Excel File WITHOUT File Reference #shorts

Learn the trick to properly copy Excel formulas without file reference: When you copy formulas from an Excel workbook to another Excel file, it creates links referencing the old file. I'll show you how you can easily fix that so the new formulas reference the new Excel file.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[amitfeb]

you improved my productivity by 10% by letting me know this trick. Thanks. Appreciated

[pluto_dp]

Tomorrow I had in plan to do this and you saved me quite some time researching a solution. Thanks.

[r.s.brousseau]

Thank you! Can’t tell you how many times I cleared the references by Find and Replace….then missing one or two or mucking up my formula.

[hansklein]

The "Edit Links" button makes it work. Or you can just copy "back" the Master sheet (in this case). Another way is select all and paste, but it doesn't always paste the right format.

[soroush.]

Great points and information same as always 👏🏻
Grateful to you Leila 🙏🏻🌺

[victoriaponciano]

Another uber fast way to copy a sheet: have both files visible on your desktop - hover mouse over tab - hold down the mouse button select 'Ctrl' - you'll see the '+' symbol - then drag that sheet to the new file and it copies the whole sheet

[MrHugawa]

just wondering about that a few days ago... thx, it's like you read my mind :)

[tong.tranquang]

this video is life-saving. Thanks much Ms. Leila.

[eversut]

Leila, I love Great video, it is soooo usefull for me.

[keithduchnicki]

Outstanding. I do this a lot. This is a great solution!

[Jamtastic]

This seems somewhat longer than just copying the link from the formula bar, going to Find + Replace (CTRL+H) and simply pasting it into the replace box, leaving the second one blank?

[edwinenriquez]

I’ll try this… what I normally do is use “Find & Replace”

[rajasekhar-lqif]

Thankyou. This is exactly what i am looking for

[llgla]

I understand what you shared. However, if you would like the same sheets and content in a 2nd file, it's easier to just make a copy of the 1st file and drag it to the new destination.

[smhameed]

Great one thanks. Can we use formula so that it should not required by edit link

[CB]

Hey Leila, any tips for ensuring columns stay intact when copying from e.g. a PDF to Excel?
It's a right pain when the text ends up going down the page instead of across!

[erikmihalj]

The best as always... but "xlxs"? 😅

[AalimOnlineOfficial]

in excel 2010, i have google drive picture url in one cell and i want to display the image in adjacent cell. possible?

[vivekjonnalagadda]

In o365 excel where edit link option is changed to workbook links, how to break multiple file links when i have more than 10 files linked and i want to break link for all 9 except one to be retained?

[lompeluiten]

Copy the file reference,
find and replace
Find: file reference
replace with: nothing.
Done!

Find and replace is my friend