In the upper left hand corner of the spreadsheet, click on the little square or use control-a to select the entire contents of the spreadsheet and copy/paste to a new workbook. (Do not use the right click on the tab to perform this function or you will copy the secutity also.) This should...
When you move the formula to another cell, Excel maintains the exact relationship (cell to cell) that was created in the first cell. A way to avoid the cell location change is to place the cursor in the formula cell address(A200) and press F4 which makes the cell location an absolute address...