How to Make a Fake Excel External Reference

How to Make a Fake Excel External Reference

by | Jul 15, 2026 | Efficiency, Excel Tips

QCustom Formula Screenshot Close QFake Reference Formula Screenshot Close QHow to Break Links Screenshot Close QBreak Links Before/After Screenshot Close Overview As a best practice, we’re often taught not to use external references in Excel.  They can easily get out...

Don't miss great tips, tricks, news, and events!

  • Get our 105 Excel Tips e-book free!
  • Get monthly insights and news
  • Valuable time-saving best practices
  • Unlock exclusive resources

Almost there! We just need to confirm the email address is yours. Please check your email for a confirmation message.

We won’t pass your details on to anyone else. By clicking the sign up button, you agree to our Terms of Use and Privacy Policy.