title: rename excel worksheet without losing formula references
body: <p>I thought it is going to be quick to what I plan to do but it is getting me no where. </p>
  
  <p>I have a huge excel file with various tabs (i.e worksheets).</p>
  
  <p><img src="https://i.stack.imgur.com/572ue.png" alt="enter image description here"></p>
  
  <p>The main worksheet (the first tab) is named Inventory. I got a modified version of Inventory worksheet which has lot of changes. So I copied this as 'NewInventory' into the excel file.</p>
  
  <p>I have lot of formulas with lookups pointing to Inventory but I need all of them to reference now to NewInventory. </p>
  
  <p>I can't rename Inventory as InventoryOLD as the references gets changed. 
  Is there a way I can have all lookup formuals (there are plenty in sheets such as Sh2, Sh3, Sh4 etc) to look at NewInventory instead of Inventory in some simple steps.</p>
  
  <p>Here is an example formula</p>
  
  <pre><code>=VLOOKUP(A2, 'Inventory'!$R$2:$R164104, 1, FALSE)
  </code></pre>
  
  <p>I don't want to change for one cell and then drag it all the way down and repeat for other cells across various worksheets.</p>
  
  <p>Please suggest.</p>