title: Simplify Old Excel Workbook with Same Formula Across Multiple Worksheets that Refer to Same Worksheet
body: <p>I have an old Excel Workbook, consists of 50 numbers of same worksheets; each worksheet contains 20 rows &amp; 100 columns array with formula refer to same array typical data/benchmark in 51th worksheet.</p>
  <p>It seems to me, the formulas taking up space and causes long loading time when open/save. Is there a simpler way to handle this? maybe define name or VBA or Power Pivot?</p>