Thanks for the post. I think you have to increase RAM with exactly the same sticks as you already have (as per Jesse's post above and XPS 8930 manual), so yes I could give 32Gb a shot, adding the two same 8Gb sticks.
Unfortunately, we are still using Excel 2007, because of the VBA in there as well as an SQL interface which would both require some (heavy) additional programming.
I wasn't at all aware of the 32bit vs 64 issue in old Excels. Odd though that it worked so well on the old machine (64bit Win7 w/12Gb) but not on the XPS 8930. At home, I have an XPS 8920 where the problematic sheet work fine on Win10 (except for copy paste which heats the CPU up and often freezes whatever is going on in the sheets).
Never short of a problem with Excel... Thx for the Microsoft support link!
Given all the issues with Excel and the cost of RAM today I would try to resolve the problem without adding more memory first. Given that you are able to run your spreadsheet on another machine with less memory I think that it is unlikely that it is a memory issue. See if this helps: https://support.microsoft.com/en-us/help/2779852/how-to-troubleshoot-available-resources-errors-in-e...
Thanks for the post and link.
1) On my XPS 8920 / Windows 10 Pro / 16GB Ram, which you would think should be the model slightly less powerful than the XPS 8930 (the only diff is i7-7700k CPU @ 4.2 GHz), Excel 2007 doesn't crash (after opening the 8sheet) but does have a problem with copy/paste which makes the sheet hang, heats the CPU (usage up to 30%) and may freeze the sheet from time to time.
2) On my old 2011 Precision T5500 / Windows 7 Pro / 12 GB RAM, there is no problem whatsoever, you can run this massive sheet and many other instances of Excel 2007 with other stuff running simultaneously! No copy/paste issues either.
3) But my shining new XPS 8930 / Windows 10 Home / 16GB Ram - couldn't get it with a Windows 10 Pro from Dell / I would upgrade later (tho TBH, not too sure that would make any tangible diff), won't open even one single instance of Excel without these memory problems!! (at least I don't have the copy/paste issue with that one, yet...)
That link is great, going to study it in detail, try and sort both the memory issue and the copy paste issue which is really frustrating as well.
Why can't all this stuff work like its supposed to from the word go?!
I have an i5-8400 8930 that originally came configured with 8 GB of 2333 MHz ram I added two modules of 8 GB 2333 MHz ram, however, the bios will only recognize them as 2133 MHz. Is there anyway to get them to the 2333 MHz? Ripjaws V F4-2666C15D-16GVB DDR4 16GB (8GB x 2)
On this site: https://gskill.com/en/product/f4-2666c15d-16gvb it says that the SPD Speed is 2133 MHz while the Tested Speed is 2666 MHz. The SPD Speed is the information stored in an EEPROM chip on a synchronous dynamic random access memory (SDRAM) memory module that tells the BIOS the module's size, data width, speed, and voltage. In some BIOS the memory speed, voltage, etc. is adjustable but I don't think it is in the XPS 8930.
Fortunately, there is little difference in performance in gaming between 2133 MHz and 2666 MHz according this article: https://techbuyersguru.com/gaming-ddr4-memory-2133-vs-26663200mhz-8gb-vs-16gb?page=0
The XPS 8930 has four DIMM slots. Which support 8GB, 16GB, 24GB, 32GB, and 64GB UDIMM DDR4 memory. Up to 2400MHz for i3 CPU and up to 2666MHz for i5/i7/i7k CPU.
Use the white slots DIMM 1 and DIMM 2 if you only have two memory modules.
The XPS 8930 memory slots are pictured below.
27 White DIMM 2
26 Black DIMM 4
25 White DIMM 1
24 Black DIMM 3
The validated configurations are below =
8GB White DIMM 1 4GB, White DIMM 2 4GB
16GB White DIMM 1 8GB, White DIMM 2 8GB
24GB White DIMM 1 4GB, White DIMM 2 4GB, Black DIMM 3 8GB, Black DIMM 4 8GB
32GB White DIMM 1 8GB, White DIMM 2 8GB, Black DIMM 3 8GB, Black DIMM 4 8GB
64GB White DIMM 1 16GB, White DIMM 2 16GB, Black DIMM 3 16GB, Black DIMM 4 16GB
Not validated but works according to a Forum customer =
48GB White DIMM 1 16GB, White DIMM 2 16GB, Black DIMM 3 8GB, Black DIMM 4 8GB
Dell validated OEM memory sticks =
TP9W1 16GB, DDR4, 2666MHz, 2RX8, 8G, 1Gx72, 8K, 288Pin, Dual Rank, Unbuffered, 1.2v, Non-ECC
Y7N41 8GB, DDR4, 2666MHz, 1RX8, 8G, 1Gx64, 8K, 288Pin, Single Rank, Unbuffered, 1.2v, Non-ECC
FDFMV 4GB, DDR4, 2400MHz, 512x8, 288Pin, Single Rank, Unbuffered, 1.2v, Non-ECC
I think there is a problem with what is in the service manual with regards to the Table 2 Memory configuration matrix. In the 8 GB & 16 GB configurations modules are installed in pairs in slots with different colored (white & black) securing tabs whereas in the 24 GB configuration matching modules are installed in slots with similar colored (white/white & black/black) securing tabs. I believe matching pairs should always be installed in slots with similar colored securing tabs. This mistake in the service manuals for the XPS 8910 and XPS 8920 also.