Excel import workaround that’s better than the original!

Well, you learn something new every day, and sometimes from the most surprising sources. Although we use Outlook for email, we had created an Asset Management application in Notes (using rich text fields to store scans of original invoices etc). We needed a way to export information from this application to an Excel spreadsheet to further manipulate it. This was where I discovered that Excel 2007 no longer imports Lotus 123 - see blog post from April 23.

A few days later the finance person using the Asset Tracker came back to me and said she had solved the export / import problem - just use "Copy as table" and paste into the spreadsheet! Wow - this finance person had never used Notes before, and come up with a work around that was much better / easier to use than the original process. (Note: Although cell background colors are preserved in Open Office, they are miss aligned. Background colors don't paste into MS Excel.) This just goes to show that you never stop learning, and that potentially anybody can teach you something.

Excel 2007 can’t open Lotus 123 spreadsheets

We hit this problem today trying to export a Notes view as a spreadsheet, and import it into Excel. Older versions of Excel could import a wk4 spreadsheet, but not so in Excel 2007. Maybe IBM / Lotus will finally provide a means to export native Excel files directly from Notes (or maybe this is just wishful thinking...!)