ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   where is confirm conversion at open in Excel 2007? ('03 tools opt (https://www.excelbanter.com/excel-discussion-misc-queries/135572-where-confirm-conversion-open-excel-2007-03-tools-opt.html)

sandibeach_2000

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