Bring Excel Workbooks/Spreadsheets into SharePoint

K

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.
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top