Results 1 to 7 of 7

Macro for data tables in financial model slowing down excel

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2021
    Location
    Berlin
    MS-Off Ver
    Microsoft Excel for Mac - Version 16.51
    Posts
    3

    Question Macro for data tables in financial model slowing down excel

    Hello,

    I have a large financial model with 4 P&L's and data tables next to them with two variables. The data tables seem to slow down the model and crashes it on some occasions, even when calculation options are set to Manual or "except data tables". I would, therefore, like to create two buttons with a macro attached to it:
    - Load data table (I basically want my data table to be empty when opening and working on the file, so that I have full performance, then be able to load it)
    - Delete data table (once I had a look at the data table and taken a screenshot, I want to delete it again to get full performance back)

    Can someone help me with an existing code for this or an alternative solution? Unfortunately I am not allowed to share the file.

    Thank you in advance!
    Last edited by berlin_21; 08-02-2021 at 08:05 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Financial model - cashflow help
    By j.mccartan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-27-2020, 10:14 AM
  2. Financial Model Not Working
    By adams2233 in forum Excel General
    Replies: 3
    Last Post: 04-16-2019, 08:13 AM
  3. Replace formulas that are slowing down Excel model significantly
    By helpmeplz_ in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-12-2018, 09:49 AM
  4. Similar Financial Forms throughout model
    By hlep in forum Excel General
    Replies: 0
    Last Post: 05-15-2012, 04:00 AM
  5. Excel question for financial model
    By kidflip in forum Excel General
    Replies: 2
    Last Post: 03-16-2011, 03:13 AM
  6. financial model
    By cassandra23 in forum Excel General
    Replies: 4
    Last Post: 12-24-2008, 12:20 AM
  7. financial model
    By sid_2007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2007, 08:32 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1