I've just upgraded to 2006 and I'm trying to bring in an Excel spreadsheet. I'm using Paste Special and it is coming in as a table object. But as I've seen on one of their Webcasts, it's not coming in with the formulas as fields or the same formatting as the original spreadsheet. I'm using an older version of Excel from Office 2000. Does anyone know if I need to upgrade my version of Excel to get this to work properly? Or am I missing something else?
Thanks.
Ken