![]() |
where is confirm conversion at open in Excel 2007? ('03 tools opt
where is confirm conversion at open in Excel 2007? ('03 tools opttions
general) I found options hidden under the multicolor office button. This is what I use it for maybe there is another way now in 2007. On the Tools menu, click Options, and then click the General tab. Click Confirm conversion at Open. At the step in the mail-merge process when you connect to your data file, after you locate the Excel worksheet you want to connect to, the Confirm Data Source dialog box opens. Click MS Excel Worksheets via DDE (*.xls), and then click OK. In the Microsoft Excel dialog box, for Named or cell range, select the cell range or worksheet that contains the information you want to merge, and then click OK. The numbers from the Excel spreadsheet will now look exactly the same in your merged documents as they look in the worksheet cells. |
All times are GMT +1. The time now is 03:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com