If you want to permanently change the source file of a link, choose Links from the Edit menu, select the link in the list, and then choose the Change Source button.
If you want the text box to automatically resize to fit the text, select the text box, click Text Box on the Format menu, ...
If you want to be asked each time you open a workbook whether to open it as read-only, choose Save As from the File menu, ...
If you want to define your own custom sort order, click Preferences on the Edit menu, and then click the Custom Lists tab. ...
If you want to freeze a row at the top of the window, select the row below it, and then choose Freeze Panes from the Window ...
If you want to permanently change the source file of a link, choose Links from the Edit menu, select the link in the list, ...
If you want to place the PivotTable on an existing worksheet, type or select the cell reference for only for the upper-left ...
If you want to print the worksheet with gridlines, choose Page Setup from the File menu and select the Gridlines check box ...
If you want to print the worksheet without gridlines, choose Page Setup from the File menu and clear the Gridlines check ...
If you want to reapply your number format when data is pivoted or refreshed, select the data field in the PivotTable, choose ...