Bring Excel Workbooks/Spreadsheets into SharePoint
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. |
Bring Excel Workbooks/Spreadsheets into SharePoint
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. "khushi" wrote: 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. |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com