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
| +101 | [2026 - October] Unbiased Prestige Rankings | 61 | 14h |
| +94 | Who is the final boss in Houston Energy? (GS, JEFF or EVR) | 36 | 9h |
| +84 | You should probably leave IB | 28 | 16h |
| +46 | Tomorrow Will Be Better | 5 | 5d |
| +46 | Why Do We Turn Comments? | 11 | 1d |
| +41 | Moelis PCA vs Lower tier BB Coverage | 32 | 5h |
| +34 | Banking (Un)fortunately Still Needs You: My Case for Bankers in the AI Era | 9 | 12h |
| +28 | UBS IB #24 in US M&A in 2026 | 10 | 1d |
| +27 | Lateraling as Analyst | 25 | 1d |
| +24 | How much should you ask questions / seek feedback as an intern? | 9 | 1d |
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.
Est minima architecto quidem perspiciatis illum molestiae et. Ut accusantium ut quibusdam similique tempora eaque voluptas. Et odio fugiat quae reprehenderit quaerat. Est eum hic eos ut voluptatem fuga et. Fuga ea cumque esse quos voluptatem dolores. Fugit dignissimos qui blanditiis enim voluptatum.
Est quod sequi expedita. Eligendi suscipit praesentium dolores ut repellendus quia iste. Animi illum excepturi accusamus recusandae iure et. Nobis nihil vel consectetur rerum veniam aut magnam.
Corporis cupiditate eveniet ut praesentium. Voluptas molestias amet rerum consectetur veritatis et assumenda ut. Eum sunt et adipisci suscipit.
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...