EXCEL 同時打開多個工作簿

 

If you usually work with a number of workbooks simultaneously, you might like the idea of opening all of your workbooks exactly where you left off the last time you closed Excel.
If so, you need to create a workspace file. Before you quit for the day, select Files, Save Workspace and specify a file name. To pick up where you left off in the last session, reopen the workspace file: Use File, Open and choose the workspace file (it'll have an .xlw extension).
Note: A workspace file contains only configuration information, not the actual workbooks and worksheets. Therefore, you can't simply copy the workspace file -- you'll need the workbook files, too.
對多個工作薄進行編輯后，執(zhí)行“文件→保存工作區(qū)”命令，取名（**.xlw）、確定保存。以后只要打開該工作區(qū)文檔，即可打開上述多個工作?。ㄗ⒁猓汗ぷ鲄^(qū)文件只是保存設(shè)置信息，并不保存文件，所以你必須對每個文件所作的更改另行保存）。