Microsoft Office Tutorials and References
In Depth Information
Importing and exporting files
INSIDE OUT Recover data using links
You can try to recover data from a corrupted workbook by using another trick. It is
essentially the same trick used by the Excel Open And Repair command, but it still
might be worth a try if Open And Repair fails.
First, open two new workbooks. Select cell A1 in one of the workbooks, and then press
Ctrl+C to copy. Activate the second workbook, and right-click cell A1. Click Paste
Special, and then click the Paste Link button. Next, click the File tab and click Edit Links To
Files on the Info screen (this command is in tiny type at the bottom of the shaded area
on the right), click Change Source, and locate the corrupted workbook. Click OK, and
then click Close to close the Edit Links dialog box.
If luck is with you, data from cell A1 in the lost workbook appears in cell A1, thanks to
the linking formula. If it does, press F2 to activate Edit mode, and press F4 three times
to change the absolute reference $A$1 to its relative form, A1. Finally, copy the formula
down and across until you can see all the data you need to retrieve. Repeat for each
worksheet in the workbook. You lose the formatting and formulas, of course, and zeros
appear in every blank cell, but at least you can get at the important stuff. Although you
can save this worksheet with linking formulas, you might consider converting all the
formulas to their underlying values, just in case the original corrupted file has any
further degradation. To do so, select all the cells containing the formulas you just created,
click Ctrl+C to copy, right-click, click Paste Special, select Values, and then click OK.
For more information about document recovery, see “Recovering from crashes” later in this
chapter. For more information about passwords, see “Hiding and protecting workbooks” in
Chapter 7.
Importing and exporting files
Excel gracefully accepts proprietary data created in many other applications. Excel also
makes it easy to import data from text files and helps you parse it into worksheet columns.
Mountains of very specific, sleep-inducing technical details are available about
importing and exporting files. If you need details, you should consult Microsoft Office Online ) . Also, for information regarding sharing data with other (
soft Office 2013 applications and working with external databases, see Chapter 32,
“Integrating Excel and Word,” and Chapter 25, “Working with external data.”
Search JabSto ::

Custom Search