With PAC Mate's support of Pocket Excel, many new and exciting possibilities await you. While a mini version of the desktop application, Pocket Excel retains many of the powerful features you need in a spreadsheet analysis program.
Like other Pocket PC applications, your Excel files are fully synchronizable with Excel on your PC.
Pocket Excel files use the extension .pxl and .pxt. During synchronization, many items in your.xls file will not convert or are changed in your .pxl or .pxt files. For instance, cell comments and hyperlinks do not convert, while borders change to single lines in Pocket Excel. However, once you synchronize and convert back to .xls these items are restored. For more information on PAC Mate Conversion changes, please see Pocket Excel's online help in the PAC Mate.
You can find the Pocket Excel application in the Programs submenu (WINDOWS Key, P, P, ENTER). The first time you open Pocket Excel, it opens by default to a blank spreadsheet so you can immediately begin entering data.
To view all the commands available in Pocket Excel, please see Appendix A: Pocket Excel Commands.
After you have created a workbook, Pocket Excel will then open first to a list view where you can choose the workbook you want to open or create a new workbook. To select a workbook in the list view, use the cursor cross to move to the workbook and then press ENTER. To create a new workbook, press ALT and press ENTER on New.
In Pocket Excel you can open only one workbook at a time. When you open a second workbook, the first one is saved and closed automatically.
To save a workbook, press ALT, move to Tools and press ENTER. From the Tools Menu, press ENTER on Save Workbook As. In the Name edit field type a name for your file. If you want your workbook to get saved in a particular folder, press TAB to move to the next control and use the cursor cross to select a folder. The next control allows you to change the workbook's format. Since this is also a combo box, use the cursor cross to select a file format. The last control in this dialog designates where you want to save your file. You have a choice of using the Main Memory or Flash Disk. To close and exit this dialog, press ENTER.
Pocket Excel workbooks can be synchronized with Excel on your PC. To synchronize files of any type, you must first create a standard partnership. Then in ActiveSync on your PC go to the Tools Menu (ALT+T) and select Options. In the Mobile Device list view, place a check in the Files' check box. When you select Files, a PACMate My Documents folder is created on your PC's desktop. Place all files you want to synchronize with the PAC Mate in this folder. Password-protected files cannot be synchronized.
All Pocket Excel files stored in My Documents and its subfolders are synchronized with the PC. ActiveSync converts documents during synchronization.
For more information on synchronization or file conversion, see ActiveSync Help on the PC.
Note: When you delete a file on either your PC or your PAC Mate, the file is deleted in the other location the next time you synchronize.
In the list view; select the file and press Application Key. To select multiple files, use the SPACEBAR+UP/DOWN ARROW. Then, press Application Key. From the Context Menu, choose Send via E-mail.
A new e-mail message is created with the file attached.