Desktop To Deal With Mega Spreedsheets
- Thread starter SBarker21
- Start date
ubuysa
The BSOD Doctor
With Excel sheets that large you'll want them loaded as fast as possible, hence an SSD.
What version of Excel do you use? If it's the 32-bit version, you are limited to 2GB RAM use.
If you want to utilise more RAM then you need the 64-bit version.
But if you choose the latter, you may also need to check any macro's or plugins that you may use
https://support.microsoft.com/en-gb...-in-the-32-bit-edition-of-excel-2013-and-2016
If you want to utilise more RAM then you need the 64-bit version.
But if you choose the latter, you may also need to check any macro's or plugins that you may use
https://support.microsoft.com/en-gb...-in-the-32-bit-edition-of-excel-2013-and-2016
Thanks for information, I had no idea 32-bit Excel was limited to 2GB RAM.
Will be upgrading to 64-bit on my current PC immediately, I have however also got a Mac which is running 64-bit and it doesnt have struggle just trying to open the spreadsheets.
So the consensus is, stacks of RAM, SSD and a solid processor? Oh and 64-bit Excel!
Thanks guys.
Will be upgrading to 64-bit on my current PC immediately, I have however also got a Mac which is running 64-bit and it doesnt have struggle just trying to open the spreadsheets.
So the consensus is, stacks of RAM, SSD and a solid processor? Oh and 64-bit Excel!
Thanks guys.
Definitely - the SSD will help loading times immensely (there's a good chance your Mac has an SSD if it's less than about 7 years old).
Plenty of RAM though honestly I don't know how much becomes too much and is wasted when talking about Excel as personally I'm far from a power-user of it.
And yeah try 64-bit Excel. As I said before, just be careful if your sheets use macros or custom plugins for compatibility- it's one of the main reasons 64-bit isn't always rolled out.
Oussebon
Multiverse Poster
Potentially something like:
Case
CORSAIR CARBIDE SERIES™ 275R TEMPERED GLASS GAMING CASE
Processor (CPU)
Intel® Core™ i7 Eight Core Processor i7-9700K (3.6GHz) 12MB Cache
--- FREE Call of Duty: Black Ops 4 & More w/ select Intel CPUs!
Motherboard
Gigabyte Z390 AORUS PRO: ATX, LG1151, USB 3.1, SATA 6GBs - RGB Ready
Memory (RAM)
16GB Corsair VENGEANCE DDR4 3000MHz (2 x 8GB)
Graphics Card
INTEGRATED GRAPHICS ACCELERATOR (GPU)
1[SUP]st[/SUP] Storage Drive
2TB SEAGATE BARRACUDA SATA-III 3.5" HDD, 6GB/s, 7200RPM, 64MB CACHE
1[SUP]st[/SUP] M.2 SSD Drive
512GB SAMSUNG 970 PRO M.2, PCIe NVMe (up to 3500MB/R, 2300MB/W)
DVD/BLU-RAY Drive
NOT REQUIRED
Power Supply
CORSAIR 550W TXm SERIES™ SEMI-MODULAR 80 PLUS® GOLD, ULTRA QUIET
Power Cable
1 x 1 Metre UK Power Cable (Kettle Lead)
Processor Cooling
Corsair H100x Hydro Series High Performance CPU Cooler
Thermal Paste
STANDARD THERMAL PASTE FOR SUFFICIENT COOLING
Sound Card
ONBOARD 6 CHANNEL (5.1) HIGH DEF AUDIO (AS STANDARD)
Wireless/Wired Networking
10/100/1000 GIGABIT LAN PORT (Wi-Fi NOT INCLUDED)
USB/Thunderbolt Options
MIN. 2 x USB 3.0 & 2 x USB 2.0 PORTS @ BACK PANEL + MIN. 2 FRONT PORTS
Operating System
Genuine Windows 10 Home 64 Bit - inc. Single Licence [KUK-00001]
Operating System Language
United Kingdom - English Language
Windows Recovery Media
Windows 10 Multi-Language Recovery Image - Unlimited Downloads from Online Account
Office Software
FREE 30 Day Trial of Microsoft® Office® 365 (Operating System Required)
Anti-Virus
BullGuard™ Internet Security - Free 90 Day License inc. Gamer Mode
Browser
Microsoft® Edge (Windows 10 Only)
Warranty
3 Year Standard Warranty (1 Month Collect & Return, 1 Year Parts, 3 Year Labour)
Delivery
STANDARD INSURED DELIVERY TO UK MAINLAND (MON-FRI)
Build Time
Standard Build - Approximately 6 to 8 working days
Quantity
1
Price £1,329.00 including VAT and Delivery
Unique URL to re-configure : https://www.pcspecialist.co.uk/saved-configurations/intel-z370-pc/NRQnbwhFrp/
MOAR RAM can be tempting and is a possibility but it's worth checking very carefully whether it's worth it.
Case
CORSAIR CARBIDE SERIES™ 275R TEMPERED GLASS GAMING CASE
Processor (CPU)
Intel® Core™ i7 Eight Core Processor i7-9700K (3.6GHz) 12MB Cache
--- FREE Call of Duty: Black Ops 4 & More w/ select Intel CPUs!
Motherboard
Gigabyte Z390 AORUS PRO: ATX, LG1151, USB 3.1, SATA 6GBs - RGB Ready
Memory (RAM)
16GB Corsair VENGEANCE DDR4 3000MHz (2 x 8GB)
Graphics Card
INTEGRATED GRAPHICS ACCELERATOR (GPU)
1[SUP]st[/SUP] Storage Drive
2TB SEAGATE BARRACUDA SATA-III 3.5" HDD, 6GB/s, 7200RPM, 64MB CACHE
1[SUP]st[/SUP] M.2 SSD Drive
512GB SAMSUNG 970 PRO M.2, PCIe NVMe (up to 3500MB/R, 2300MB/W)
DVD/BLU-RAY Drive
NOT REQUIRED
Power Supply
CORSAIR 550W TXm SERIES™ SEMI-MODULAR 80 PLUS® GOLD, ULTRA QUIET
Power Cable
1 x 1 Metre UK Power Cable (Kettle Lead)
Processor Cooling
Corsair H100x Hydro Series High Performance CPU Cooler
Thermal Paste
STANDARD THERMAL PASTE FOR SUFFICIENT COOLING
Sound Card
ONBOARD 6 CHANNEL (5.1) HIGH DEF AUDIO (AS STANDARD)
Wireless/Wired Networking
10/100/1000 GIGABIT LAN PORT (Wi-Fi NOT INCLUDED)
USB/Thunderbolt Options
MIN. 2 x USB 3.0 & 2 x USB 2.0 PORTS @ BACK PANEL + MIN. 2 FRONT PORTS
Operating System
Genuine Windows 10 Home 64 Bit - inc. Single Licence [KUK-00001]
Operating System Language
United Kingdom - English Language
Windows Recovery Media
Windows 10 Multi-Language Recovery Image - Unlimited Downloads from Online Account
Office Software
FREE 30 Day Trial of Microsoft® Office® 365 (Operating System Required)
Anti-Virus
BullGuard™ Internet Security - Free 90 Day License inc. Gamer Mode
Browser
Microsoft® Edge (Windows 10 Only)
Warranty
3 Year Standard Warranty (1 Month Collect & Return, 1 Year Parts, 3 Year Labour)
Delivery
STANDARD INSURED DELIVERY TO UK MAINLAND (MON-FRI)
Build Time
Standard Build - Approximately 6 to 8 working days
Quantity
1
Price £1,329.00 including VAT and Delivery
Unique URL to re-configure : https://www.pcspecialist.co.uk/saved-configurations/intel-z370-pc/NRQnbwhFrp/
MOAR RAM can be tempting and is a possibility but it's worth checking very carefully whether it's worth it.