+ Reply to Thread
Results 1 to 3 of 3

Different version of Excel caused error in sharepoint

  1. #1
    Forum Contributor aprildu's Avatar
    Join Date
    04-13-2014
    Location
    Barrie,On, Canada
    MS-Off Ver
    Excel 2016
    Posts
    175

    Different version of Excel caused error in sharepoint

    The macro routine works in a sharepoint folder for one user who has office 365 however another user with a older version of excel seems to not be able to even open the file. The error occurred when the user clicked on the link in an email which pointed to the file in the sharepoint folder. It jumped right to the workbook_open routine. Any help appreciated!
    Last edited by aprildu; 09-19-2018 at 03:58 PM.

  2. #2
    Forum Contributor
    Join Date
    07-01-2009
    Location
    Maine, USA
    MS-Off Ver
    Excel 2016
    Posts
    161

    Re: Different version of Excel caused error in sharepoint

    Check and make sure you save as a DOC and not DOCX. Also make sure you have compatibility checked for that file.

  3. #3
    Forum Contributor aprildu's Avatar
    Join Date
    04-13-2014
    Location
    Barrie,On, Canada
    MS-Off Ver
    Excel 2016
    Posts
    175

    Re: Different version of Excel caused error in sharepoint

    It's an excel macro routine. The file is saved in a sharepoint folder. The users who has office 365 sent a link of the macro enabled file (sharepoint path) but the other user encountered the error once clicking on the link. As far as I know the other user uses office earlier version (for example excel 2010).
    Last edited by aprildu; 09-20-2018 at 07:18 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] how do I open a version controlled spreadsheet on SharePoint?
    By flyboy54 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2014, 01:47 PM
  2. Replies: 1
    Last Post: 04-30-2012, 12:07 PM
  3. [SOLVED] Error caused by *.xls file
    By WLMPilot in forum Excel General
    Replies: 0
    Last Post: 07-27-2006, 10:25 AM
  4. [SOLVED] Error caused by *.xls file
    By WLMPilot in forum Excel General
    Replies: 0
    Last Post: 07-27-2006, 10:20 AM
  5. Error caused by *.xls file
    By WLMPilot in forum Excel General
    Replies: 0
    Last Post: 07-27-2006, 10:15 AM
  6. Excel Caused Error in VBE6.dll. Excel will Close
    By mikeF in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-03-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1