we often come across this situation, when one person opens the excel sheet, other person can not open the same one to edit or view it. This can be avoided by using share work book concept in excel sheet.
Use the following Link to know how to do it.
How to use shared workbooks with different versions of Excel
You cannot share an Excel workbook that contains an array formula that is linked to another workbook
Use the following Link to know how to do it.
How to use shared workbooks with different versions of Excel
You cannot share an Excel workbook that contains an array formula that is linked to another workbook
No comments:
Post a Comment