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
not sure if it matters or not but thats when everything stopped working.
Bookmarks