Recent content by GixxerG

If a spreadsheet that contains links to another is opened, it will prompt to "Update links". If you respond "yes", excel will attempt to re-establish these links. However as the linked file has been deleted in your case, you should respond "no" and therefore the...

This is a doozey. Our network administrators have disabled the ability for users to retain certain profile elements. Therefore my problem is that each time I launch excel, the macro security (Tools/Macro/Security), irrespective of how I change it, reverts back to "Medium" and this in...

No worries! .

I've found that a common reason excel files appear unusually large is due to inadvertant cell formatting. e.g. if I've given global volumes of cells attributes that I didn't need to and this in turn has blown up the file size. Consequently to copy only the necessary cells to a new file...

If by 50 pages you mean 50 sheets (and assuming you don't do this regularly which would then be best automated with vba), then I'd suggest selecting all the relevent sheets by shift-clicking on each sheet tab that will require the input "Central District" and then simply typing...