• A.CRE
    • A.CRE Home
    • A.CRE Accelerator
      • Learn More
      • Login
      • Manage Membership
    • Artificial Intelligence
    • Careers
    • Consulting and Advisory
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
    • University Profiles
    • Contributors
  • FAQs
  • Knowledge Base
  • Contact Us
  • A.CRE
    • A.CRE Home
    • A.CRE Accelerator
      • Learn More
      • Login
      • Manage Membership
    • Artificial Intelligence
    • Careers
    • Consulting and Advisory
    • CRE Event Calendar
    • CRE Job Board
    • Education
    • Library of Excel Models
    • University Profiles
    • Contributors
  • FAQs
  • Knowledge Base
  • Contact Us
home/Knowledge Base/I have a question about a model.../After creating a new workbook and putting in new data, the returns are still based on the original model
Popular Search:How do I, What is, Why

After creating a new workbook and putting in new data, the returns are still based on the original model

5 views 0 August 12, 2020 Updated on November 26, 2022

It sounds like the Excel workbook you’re working with has retained links to a previous Workbook you created – you can confirm by going to the ‘Data’ ribbon and clicking ‘Edit Links’. This means that certain inputs on the new Workbook are being pulled from the previous Workbook, and the only way to fix this is to manually edit the inputs where those links were created.

Learn more about how to break external links in Excel.

To identify if a link was created, mouse into cells in the new Workbook and in the formula bar look for the name of the previous Workbook in that formula. You would then need to edit the new Workbook to remove every one of those links, such that they link to the information within the new Workbook. Depending on how many links there are, this could take a lot of time. It may be more appropriate to just return to the previous Workbook and copy the data over to a fresh copy of the All-in-One model.

Spencer has created a Best Practices in Real Estate Financial Modeling Guide that addresses these sorts of cross-Workbook links, and how to avoid them when copying from one Workbook to another.

Was this helpful?

Yes  No
Related Articles
  • Strikethrough Lines Appear in Certain Cells After Downloading and Using an A.CRE Model
  • Are there any limitations in the ORI Module of the All-In-One Model?
  • Waterfall Distribution % and Promote Calculation
  • Microsoft has blocked macros from running because the source of this file is untrusted. What do I do?
  • Trouble downloading a model?
  • Would you please tell me how to change completion date for the Condominium Development Model?

No luck finding what you need? Contact Us

Leave A Comment Cancel reply

You must be logged in to post a comment.

I have a question about a model...

  • After creating a new workbook and putting in new data, the returns are still based on the original model
  • Strikethrough Lines Appear in Certain Cells After Downloading and Using an A.CRE Model
  • Microsoft has blocked macros from running because the source of this file is untrusted. What do I do?
  • Trouble downloading a model?
  • Macros are disabled – I downloaded your model and the macros are disabled. How do I enable them?
  • Geocode script doesn’t work – The A.CRE Geocoding Add-in for Excel, nor the text-based module (VBA code) works.
View All 16  

Popular Articles

  • Argus vs. Excel vs. Others – And Why the Focus on Excel?
  • Do you have any calculators for yield maintenance pre-payment penalty on multifamily loans?
  • I need help to modify (customize) the model
  • As a college student with no experience, do you recommend I take the ARGUS certification training and exam?
  • What happens when my Accelerator Membership Expires?

KB Categories

  • The Accelerator (Non-member
  • The Accelerator (Members
  • Website Troubleshooting
  • I have a question about a model…
    • A.CRE Geocoding Excel Add-In
    • All-In-One
    • 3-Tiered Acquisition Debt Module
    • Actual + Forecast Construction Draw Schedule
    • Advanced Amortization Model
    • Apartment Acquisition Model with Monte Carlo Simulation Module
    • Apartment Development Model
    • Back-of-the-Envelope Office, Retail, Industrial Acquisition Model
    • Basic Hotel Acquisition Model
    • Commercial Mortgage Loan Analysis Model
    • Condominium Development Model
    • Construction Draw and Interest Calculation Model
    • Ground Lease Valuation Model
    • Equity Waterfall Model with Monthly Periods
    • Excel Pro Forma for Flipping Houses
    • Hotel Acquisition 2.0
    • Hotel Development Model
    • Hotel Valuation Model
    • Industrial Real Estate Development Model
    • Loan Payment Schedule and Balance Tracking Tool
    • Mixed-Use Development Model: Condo and Retail
    • Multifamily Apartment Acquisition Model
    • Multifamily Redevelopment Model
    • Multifamily Value-Add Acquisitions
    • Real Estate Acquisition Due Diligence Checklist
    • Real Estate Acquisition Model – 2.0
    • Real Estate Capital Account Tracking Tool
    • Real Estate Portfolio Valuation Model
    • Residential Land Development Pro Forma
    • S-Curve Forecasting
    • Self Storage Development Model
    • Simple Acquisition Model for Office, Retail, and Industrial
    • Single Family Home Construction Pro Forma for Home Builders
    • Single Family Residential Investment Analysis Model
    • Single tenant NNN Lease Valuation Model
    • Value-Add Apartment Acquisition Model
    • 4-Tier Equity Multiple Waterfull
    • Waterfall Model for Real Estate Joint Ventures with Catch-Up
    • Waterfall Model with Cash-On-Cash Hurdle
    • Waterfall Model with Catch Up and Clawback
    • Waterfall Model with IRR and Equity and Multiple Hurdles
  • What model should I use for…?
  • Career Advice
  • Financial Modeling Questions

  Are all models easily expandable or do I need to customize?

Not finding an answer to your question?

Click here to contact us

About A.CRE

Adventures in CRE is the most popular real estate financial modeling, education, and careers website on the web. Use this section to get help with models, the site, or the Accelerator.

Help Sections
  • A.CRE Help
  • My Account
  • FAQs
  • Knowledge Base
  • Glossary
Knowledge Base

I have a question about a model…

What model should I use for…?

The Accelerator (Non-member)

The Accelerator (Members)

Career Advice

A.CRE

A.CRE Home

Join the Accelerator

Download a Model

CRE Careers

 

 

 

  • Privacy Policy
  • Terms of Use
  • © Adventures in CRE, LLC. All Rights Reserved.

Popular Search:How do I, What is, Why