Bring Excel Workbooks/Spreadsheets into SharePoint

[khushi]

Hi there,
I have a task to bring existing Excel spreadsheets into sharepoint site.
These spreadsheets are heavily equipped with macros having complex
formulas/logics. I know how to import excel sheet into sharepoint as a custom
list but what to do about the macros and functionalities to carry on. The
whole account application is based on macros in workbooks/spreadsheets.
I want to know what are various ways to accomplish this task and their
advantages and disadvantages. Also, What would you recommend is the best
approach to do this.
I would be very grateful, if you can forward me any resource that can
help me to dig out more about this topic to explore.

 

[dhstein]

I believe macros are not supported in Sharepoint as a custom list. You have
to save the excel file as is and only users who have Excel can read or open
those files.