+ Reply to Thread
Results 1 to 3 of 3

array formula turning off on different computer

  1. #1
    Forum Contributor
    Join Date
    03-10-2017
    Location
    USA
    MS-Off Ver
    office 2016
    Posts
    393

    array formula turning off on different computer

    I have a workbook that I made on my computer and everything works fine but when I gave the program to another person or tried it on another computer of mine all the array formulas stopped working. If I went back in and re entered the cntr+alt+enter then it started working again. The odd thing is that it shows the formula as an array formula (with the {} around the formula) but it didnt work until I re-entered it. Any ideas why this is happening? My program is very large (80 meg) so I cant post a copy here and i wonder if its size is causing issues.... LOTS of calculations going on.

    Edit: It all started when I added a bunch of formulas like this

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    not sure if it matters or not but thats when everything stopped working.
    Last edited by kevinu; 01-20-2019 at 08:14 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: array formula turning off on different computer

    I have not heard of this problem before but your file is rather large and the size of the file could be a complicating factor. What are the differences in CPU and also in the version of Excel you are using on the two different computers?

    Do you have calculation set to Manual or Automatic?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    03-10-2017
    Location
    USA
    MS-Off Ver
    office 2016
    Posts
    393

    Re: array formula turning off on different computer

    The computer it works on has an i5 with 64bit excel, the one it doesn't work on is i7 with 32bit excel. Both have same ram. I have automatic calculations on.

+ 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. Identical VBA Code works on computer A, throws error on computer B???
    By PWM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2018, 08:15 AM
  2. Replies: 3
    Last Post: 05-18-2018, 08:20 AM
  3. [SOLVED] Array formula turning my final figure into a minus value
    By chrisandsally in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2015, 12:36 PM
  4. Replies: 6
    Last Post: 06-28-2013, 08:44 PM
  5. Taking a range as an argument, and turning it into an array for manipulation
    By Huugin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2012, 07:48 AM
  6. Auto Filter on my home computer differs from my work computer.
    By Sbova0226 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-08-2009, 03:04 PM
  7. Turning Two Columns of Data into an Array
    By Dexsquab in forum Excel General
    Replies: 7
    Last Post: 02-01-2006, 08:40 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