+ Reply to Thread
Results 1 to 4 of 4

getting pop up message in saving xlsm as files are in xls with macros

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    getting pop up message in saving xlsm as files are in xls with macros

    I have an issue, recieved a workbook with format .xls 97 -2003 , in opening excel warns me of macros which I enabled, there are 3 sheets group ready for printing .

    But doing some work and inserting my macros and saved to xlsm.

    I got this message as attached Can anyone explain me what it is ,it's the first time I got such message , and how to get rid of it
    Attached Images Attached Images

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: getting pop up message in saving xlsm as files are in xls with macros

    Hi

    Versions of Excel prior to 2007, i.e. 97-2003 had a maximum 256 columns, the last one being IV
    Since 2007 there have been 16384, the last being XFD
    The reference to RF1 is identifying the fact that RF1 when interpreted as a column is 474 so Excel 97-2003 is complaining and saying it can't compute.
    Save the file as a .xlsm file with a version of Excel 2007 or later.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,813

    Re: getting pop up message in saving xlsm as files are in xls with macros

    That reference could be interpreted by Excel (2007 and later) as meaning the cell RF1. This wouldn't have been a problem in earlier versions of Excel (i.e. those that used .xls extension), as there were only 256 columns available, so cell references only went up to column IV, but later versions have column references which go up to XFD. The warning tells you that instead of using the name rf1, this has been changed to _rf1 (i.e. with an underscore in front of it), and that you may need to make manual changes yourself in any text values that make use of the original name, or any macros which make use of it, because these will not be changed automatically.

    Hope this helps.

    Pete

  4. #4
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Re: getting pop up message in saving xlsm as files are in xls with macros

    Hi Richard & Pete

    Thanks for explanation, now I understand the why

    Regards

    Jean

+ 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. Saving an xlsm as an xlsx
    By Steven811 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2016, 07:28 AM
  2. Replies: 0
    Last Post: 05-20-2014, 12:01 PM
  3. Replies: 2
    Last Post: 10-04-2013, 10:12 AM
  4. Saving macros as global addins or personal.xls files
    By Lighthouse13 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-12-2010, 08:20 PM
  5. error message when saving files
    By helen_spencer9 in forum Excel General
    Replies: 1
    Last Post: 11-07-2008, 11:17 AM
  6. Macros and saving .csv files
    By whatageek in forum Excel General
    Replies: 4
    Last Post: 06-26-2006, 09:10 AM
  7. Error message saving all excel files to network share
    By Glynn Barnard in forum Excel General
    Replies: 1
    Last Post: 02-10-2005, 02:06 PM

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