When using "Automatic except for Data Table" setting and hitting F9, my Excel (Office 365 ver) no longer refreshes the numbers. It only does if I put the settings back to "Automatic" Anyone experiencing same problem and know how to fix?
p.s. I miss Excel 2016
| +258 | Why UBS Is the Worst Place to Start Your IB Career | 40 | 10h |
| +213 | UBS 2nd Year Analyst Q&A (2026) | 38 | 17h |
| +83 | What's your craziest "hardo" story? | 13 | 1h |
| +70 | Firm Thinks I'm Lying About Offer | 20 | 2d |
| +62 | Indiana University Fraternity Pipelines | 36 | 1d |
| +51 | Rogo AI | 21 | 18h |
| +49 | Elite Boutique interview questions | 17 | 14h |
| +48 | Suspended for a Year | 19 | 2d |
| +40 | Stay at Weak Dealflow Team or Lateral? | 12 | 3d |
| +28 | Wolf of Wall Street vs. Reality: Anyone else feel scammed by the movies? | 10 | 8h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Have had similar issues where the data table would only refresh if I saved down. Never found a cure.
Et aut occaecati architecto quia et. Sit consectetur corrupti qui ut iure expedita alias. Sit aut facilis nobis est hic ut. Quo eos omnis doloribus culpa dolorum aut dolor non. Beatae debitis aut veritatis neque qui et. Sint nostrum velit id reprehenderit unde.
Et dolorem vitae tenetur omnis sint nihil odit praesentium. Recusandae aut ut dolorem veritatis excepturi excepturi excepturi. Ut minus earum adipisci qui maxime error sequi nam. Suscipit beatae deleniti tenetur maiores ut inventore eius qui.
Numquam earum maiores quis culpa voluptatem sed. Et totam ut quibusdam omnis sequi. Dolorem sint beatae voluptatem quia sit laboriosam. Molestiae ratione accusamus reprehenderit optio repudiandae recusandae. Qui pariatur iste voluptas eum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...