user-defined functions on Excel

At work I use a Windows PC and i am planning on buying a
laptop in the next few days. I would love to buy a
Powerbook or iBook. However it would be absolutely
critical that the excel spreadsheets we use at work
funtion well on a Mac. My main sheet is quite complex,
there three workbooks with links to each other, and more
than 10 sheets per workbook. We also run functions written
in visual basic (no macros, just functions). I would like
to know if, in your experience, such a mammoth spreadsheet
would work well and seamlessly when copied onto a Mac?
Less critical but also important we have other
spreadsheets with links to non-excel applications (mainly
financial databases such as Bloomberg and reuters
terminals). Would that work on a Mac too?

Many thanks

In article <17c5001c44980$eae8bfa0$a501280a@phx.gbl>,
"Marcio" <anonymous RemoveThis @discussions.microsoft.com> wrote:

 > At work I use a Windows PC and i am planning on buying a
 > laptop in the next few days. I would love to buy a
 > Powerbook or iBook. However it would be absolutely
 > critical that the excel spreadsheets we use at work
 > funtion well on a Mac. My main sheet is quite complex,
 > there three workbooks with links to each other, and more
 > than 10 sheets per workbook. We also run functions written
 > in visual basic (no macros, just functions). I would like
 > to know if, in your experience, such a mammoth spreadsheet
 > would work well and seamlessly when copied onto a Mac?

Seamless is hard to tell without knowing exactly what the UDFs do. The
worksheet functions will work, as will links. MacXL uses VBA5, so if
your functions use VBA6 commands (e.g., Replace, Split, Join, etc), they
won't work correctly. If you're familiar with VBA, there are easy
workarounds that I could give you if you need them.<!-- ~MESSAGE_AFTER~ -->