PCSTATS Main Page Follow PCSTATS on Facebook PCSTATS RSS Feed PCSTATS Twitter Feed + Motherboards
+ Videocards
+ Memory
+ Beginners Guides...
News & Advanced Search  Feedback?
[X]   Directory of
Guides & Reviews

Beginners Guides
Weekly Newsletter
Archived Newsletters

Contact the Suite 66 Advertising Agency

Beginners Guides: Hard Drive Data Recovery
  More PCSTATS Reviews... and Beginners Guides.
Beginners Guides: Flash Memory Data Recovery and Protection
Beginners Guides: Most Common Ways to Kill a PC
How Motherboards Are Made: A Gigabyte Factory Tour
Beginners Guides: Repairing a Cracked / Broken Notebook LCD Screen

Tips RSS News Feed - PCSTATS
... 0 news stories awaiting approval  
Office 2013 Crashes on Start Up - Solved - PCSTATS TechTip
     Thu, Feb 26 2015 | 2:20P | Tips | PermaLink
Posted by: STAFF
"After a couple days reading through posts about disabling Office Add-ins in vain attempts to get Office 2013 applications to NOT immediately crash on start up... PCSTATS has found the solution. We've tested it and it works. If Outlook 2013, Excel 2013, Word 2013 or another program in Office 2013 is crashing the moment you start the program, here's what you need to know to fix things."

PCSTATS TechTip: Excel Cannot Complete this Task with Available Resources - SOLVED
     Mon, Oct 27 2014 | 2:58P | Tips | PermaLink
Posted by: STAFF

PCSTATS TechTip: SOLVED - Excel Cannot Complete this Task with Available Resources...

So, you have a massive 45MB Excel spreadsheet open with multiple pages and you're about to update a few thousand cells when this error box pops up: "Excel cannot continue this task with available resources. Choose less data or close other applications. Continue without Undo?" What to do?! This can be a frustrating experience, especially if you're certain the computer is powerful enough and has 4GB or more RAM installed. The issue is indeed resources related, but adding more memory will not fix things. If for example you have Chrome or Firefox open with a couple dozen tabs at the same time, closing that browser while working in Excel can help alleviate the resource limitation... but not always.


A PCSTATS reader who uses Microsoft Office Home and Business 2013 recently wrote in for help with this problem . Here's the permanent way to solve the "Excel Cannot Complete Task with Available Resources" error.

How to Fix: Excel Cannot Complete Task with Available Resources Error

To begin with, confirm you are running the 64-bit version of Microsoft Windows 7 or 8 operating system. Next launch Excel, then open up 'Task Manager' (right click on taskbar > Start Task manager) and navigate to the 'Processes' tab. You should see "Excel.exe *32" listed. If that's the case, the reason Excel is crapping out when you work with large .xlsx spreadsheets is because 32-bit Excel is installed and 32-bit Excel can only address 2GB of system RAM. Excel needs more system resources, but for that you MUST install the 64-bit version of Microsoft Office.

To do that, uninstall Office 2013 and reinstall the 64-bit version of Office 2013. This is easily done from the 'Office Home and Business 2013' disk by 1) CANCELLING the setup.exe program which immediately loads and then 2) navigating on the Office disk to the folder '/office' and double clicking on 'setup64.exe'. This will force Office 2013 to install the 64-bit version -- the default installer loads the x32 version of Office which is compatible with both x32 and x64 operating systems.

That's it! With the 64-bit version of Microsoft Office Home and Business 2013 installed Excel will address as much memory as is installed & available to applications. This PCSTATS TechTip can be applied to Office 2010 which also comes in x32/x64 flavours. If you want to confirm you've installed the x64 version of Office 2013, launch Excel, then open up 'Task Manager' (right click on taskbar > Start Task manager) and navigate to the 'Processes' tab. You will now see "Excel.exe" listed, which means a native x64 application is running in the x64 version of Windows 7/8 operating system.

For good measure, you can also take the extra step of installing 64-bit version of Chrome Beta.


PCSTATS TechTip - Automatically Shut Down Windows at a Certain Time
     Mon, Jan 27 2014 | 2:11P | Tips | PermaLink
Posted by: STAFF

Boardroom PCs usually get forgotten about after meetings conclude and staff walk away from the room. Since these infrequently accessed PCs tend to have Hibernation disabled, they can remain powered up for days on end doing nothing but consuming electricity.

I decided to tackle the problem with Windows 'Sheduled Tasks' by configuring the computer to automatically close all programs and shut itself down at the end of the business day. Scheduled Tasks is a powerful tool built into Windows 7 that most IT Admins overlook, but is incredibly handy when you need to fun custom batch script or a pre-defined program... we're not even scratching the surfce in this brief TechTip.

Anyway, to automatically shut down a computer at a pre-determined time, go to Start > Control Panel > Administrative Tools > Task Scheduler. In Task Manager choose the 'Action' menu > Create Basic Task > name it "AUTO_Shutdown" and click next > select "Daily" > leave the start date as is and update the time to when you want the computer to shutdown, say "6:00:00PM." Set it to recur every "1" days > choose "start a program" > click "browse" and navigate to "c:\windows\system32\shutdown.exe". In the Add Arguments feild, type: "/s /f" without the outside quotes. Click Next, check the "open the priorities box..." button. > Finish. Check "run whether user is logged in or not", OK > enter your Windows log in credentials and click OK one last time.

If you now click on "Task Scheduler Library" in the left hand pane of the Task Sheduler window you'll now see the 'AUTO_Shutdown' task you've just created, listed.
Double click on this and then right click > Properties if you want need to adjust when the task runs, or right click > Delete. When the task runs, a box will pop up that says "Windows will shut down in less than a minute", then all open programs will be forced close and the PC automatically shut down.

Problem solved, power saved!

Catch the rest of PCSTATS TechTips on our Facebook page.


PCSTATS TechTip - More to Calculator than you think
     Mon, Jan 13 2014 | 2:05P | Tips | PermaLink
Posted by: STAFF
There's more to Windows Calculator than meets the eye... I bet you already know that Calculator can flip between Scientific, Programmer and Statistical mathematical functions by going to the View menu and changing it from Standard mode. Did you also know it can calculate the down payment on a 25-year mortgage? (Go View > Worksheets > Mortgage and fill in the form to the right) Or that it contains Unit Conversion, so for example when the civilized world reports temperatures of -25 degrees Celsius, you can convert that to degrees Fahrenheit or even Kelvin.
The Worksheets also include Vehicle Leasing and Fuel Economy calculators in imperial and metric. Lastly, if you need to find out how many days till Christmas 2014, go View > Date Calculation and it'll spit out the answer in months, weeks and days, or straight days. In Windows 7 launch Calculator by Start > All Programs > Accessories > Calculator.
Catch more PCSTATS TechTips like this on our Facebook page - LikeUs to get the Tips as they're posted!


PCSTATS TechTip - Fix Excel Being Extremely Slow to Opening Network Files
     Mon, Jan 06 2014 | 2:05P | Tips | PermaLink
Posted by: STAFF

Accountants will want to pay attention to this PCSTATS TechTip.

Here's what usually happens; someone in accounting goes to open up an Excel spreadsheet stored on another users computer. They navigate across the network to the folder share, locate the .xls file and double click it. After waiting for a minute or possibly several minutes, the spreadsheet finally opens. Perplexed by this slowness, the user who owns the file will usually try opening it up on their PC system and find it responds immediately, so what gives?

The extremely slow response is not because your office Ethernet network is slow, the computer is out of RAM or antivirus is gumming up the works, it's because of something called "Microsoft Office File Validation". This comes into play with Excel 2003 and sometimes Excel 2007 files. OFV causes excel spreadsheets accessed over a network to open painfully slowly, even if the file itself isn't very large.

PCSTATS can help you fix this problem with a simple Registry hack. We found it most reliable to apply the registry fix on both source and destination computers.

First, exit Excel 2003. Then go 'Start' > 'Run' > type 'regedit'. Navigate to 'HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\11.0' and right click on '11.0' to bring up the properties menu > select 'New' > select 'key' > type "Excel" and hit Enter. Right click on "excel" > 'new' 'key'> type "Security" and hit Enter. Right click on "security" > 'new' 'key'> type "FileValidation" and hit Enter. Right click on "FileValidation" > 'new' 'DWORD Value'> type "EnableOnLoad" and hit Enter. EnableOnLoad will automatically be set to a value of '0' which disables OFV.

Most tips for this issue stop there, but in our office network where there is a mix of Office 2003, 2010 and 2013 we found it necessary to repeat this Registry hack for HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\11.0, ...\12.0 and ...\14.0.

After that's all done Excel files open across the network normally! Catch more PCSTATS TechTips like this on our Facebook page - LikeUs to get the Tips as they're posted!


AMD fans rejoice
     Thu, Oct 10 2013 | 12:01P | Tips | PermaLink
Posted by: STAFF
AMD's latest Radeon product launch features no less than three cards, and we take a look at two of them today: the R9 270X and the R7 270X. They're part of a new lineup of cards is intended to herald AMD's desire to replace the Radeon HD 7000 series by the end of the year. The R9 270X and R7 260X target the mid-range market with prices starting at $199 and $139, respectively

TIP - Windows 8 and Bringing back the Start Menu
     Thu, May 02 2013 | 5:27P | Tips | PermaLink
Posted by: STAFF
Once Microsoft Windows 8 Consumer Preview boots to the virtual machine desktop you'll be presented with the totally new 'Metro' user interface. It will take a bit of learning to get used to this maze of icons.... navigation is very different and we here at PCSTATS found it quite frustrating, at first.

To get rid of Windows 8 Metro user interface and bring back the familiar Start Menu, here's what you have to do is this....


TechTip - Bring Back the Quick Launch Bar in Windows 7
     Thu, May 02 2013 | 5:27P | Tips | PermaLink
Posted by: STAFF
"To add the toolbar back, you’ll want to right-click on an open area of the taskbar, and choose Toolbars \ New Toolbar from the menu. You should probably also unlock the taskbar at this point. Now’s the slightly tricky part… you’ll want to paste the following path into the location bar:

%appdata%\Microsoft\Internet Explorer\Quick Launch

Make sure that the location bar shows the full path and click okay. You’ll immediately notice the Quick Launch toolbar on the taskbar..." "


Windows 8: How to Bypass Metro and Boot Directly to the Desktop Interface
     Wed, Oct 31 2012 | 7:29P | Tips | PermaLink
Posted by: STAFF
I've been running the Windows 8 Consumer Preview for a few months and although I'm okay with Metro replacing the Start Menu, I hate seeing the new interface by default every time I reboot. When Windows 7 starts, you hit a login screen (assuming it's enabled) and then you're brought straight to the desktop. When Windows 8 starts, it displays a lock screen that you have to move out of the way before entering your credentials, and then you have to dismiss the Metro interface before accessing the desktop. Like I said, I'm cool with Metro, but I have no desire to see a full-screen Start Menu when I log into my PC.

HotHardware's 2012 Back To School Shopping Guide
     Tue, Aug 28 2012 | 12:02P | Tips | PermaLink
Posted by: STAFF
It's back-to-school season again, and whether you've started classes recently or are awaiting (dreading?) that first 8AM lecture, there may be a few bits of techno-shopping that need to be taken care of before you can be on your way to that straight-A report card. Whether you're about to begin the fall semester of college or your senior year in high school (or something else entirely), you'll probably need the right hardware to get you through. In the pages to come, we're taking a look at today's latest and greatest when it comes to systems, hardware and peripherals that could prove useful for any dutiful student. Handling 21 hours of classes while still maintaining some sort of social life (which can mean posting daily on Twitter or Facebook) is hard work, and it's even harder if you're still relying on that old Pentium-based notebook and a Moto RAZR...

News: TRs back-to-school 2012 system guide
     Thu, Aug 16 2012 | 7:27P | Tips | PermaLink
Posted by: STAFF
We`ve updated our famous system guide to account for some of the latest hardware releases, including Nvidia`s new GeForce GTX 660 Ti. In the spirit of the back-to-school season, we`ve also added the Dorm PC 2.0, a sub-$700 Mini-ITX system that has enough brawn to handle the latest games."

[Tech ARP] Slow Menus In Adobe Photoshop CS6
     Tue, Jun 19 2012 | 9:23A | Tips | PermaLink
Posted by: STAFF
Those who have tried Adobe`s Photoshop CS6 beta or the recently-released final version may come across a really odd problem - very unresponsive menus. These symptoms will only occur when there`s an open file, and it seems to only affect notebooks with switchable graphics (Intel HD Graphics paired with an AMD or NVIDIA graphics card). Perhaps that`s the reason why there has been so little noise about this problem online. We think we figured out what was causing this problem..."

Crash Recovery & The Blue Screen of Death
     Wed, Jan 18 2012 | 5:54P | Tips | PermaLink
Posted by: STAFF
"A typical Windows BSOD message is divided into four parts, and actually does display some helpful clues as to what caused its appearance. Reading a BSOD is not an everyday task, but if we take a moment to dissect it, you'll see it can help us to resolve the conflict which is stopping Windows from operating correctly."

Tech Tip: Enable Concurrent Desktop Sessions in Windows
     Fri, Jan 06 2012 | 1:30P | Tips | PermaLink
Posted by: STAFF
Remote Desktop in server editions of Windows by default supports two concurrent connections to remotely troubleshoot or administer a computer. However, there are a few reasons why concurrent sessions would come in handy for power users not necessarily running a server. For example, if you have a dedicated Media Center PC running in the living room, you'll be able to remotely access all files on the machine without interrupting the person watching TV. Or if you are sharing a computer with other users, concurrent Remote Desktop sessions will allow more than one person use that system under a different or even the same user account, without kicking each other off.

PCSTATS TechTip... Sort an Excel spreadsheet by email domain?
     Wed, Aug 24 2011 | 4:15P | Tips | PermaLink
Posted by: STAFF

PCSTATS TechTip... Sort an Excel spreadsheet by email domain?

Q: I need to update my websites' news mailing list and remove duplicates, how do I sort the email list in Microsoft Excel by the domain names only? By default Excel sorts everything in front of the @ symbol alphabetically, I need to sort alphabetically everything following the @ sign. Help!

A: By using Data > Sort in Excel it is possible to do this, but first we'll need to pre-format the email mailing list somewhat.
First off, assuming all your email address are listed in Column A (one email address per row), create a second Column in the Excel document so we can use a formula to output only the data following the @ sign in Column A;
=MID(A1, FIND("@",A1, 1)+1, 255)
Paste the above formula into the first cell of Column B, as you'll see, this formula outputs only the domain part of the email address. Click on that cell and hover the mouse over the bottom right-hand corner of the box until you see the cursor turn into a "+" sign. Now click and drag the checkered box down to the very last row of data to copy the formula across all rows.

Next, select all your data by highlighting Column A and Column B in the margins, then go to Data > Sort > and under 'column' choose 'column B' and press 'okay'. This will tell Excel to sort all the data, alphabetically by the domain names in Column B, from there you can easily find and remove the duplicates.


Etymotic Research Custom Tips by ACS
     Mon, Apr 18 2011 | 4:00P | Tips | PermaLink
Posted by: STAFF
"Etymotic earphones may already be a pricy proposition for the average consumer, but the discerning listener is aware of the importance of a good seal in obtaining the best sound quality from an in-ear earphone. Is it possible that a mere set of eartips can be worth the $100 asked by ACS and Etymotic for the service? I decided to lay my own ears on the line and find out."

Tips NEWS PAGE: of 2    
Hardware Sections     02/26/2020 | 4:56AM  
Beginners Guides
RSS Newsletter
RSS News
Mouse Pads
Cases and Access.
Computers / SFF PCs
Cooling - Heatsinks
CPU / Processors
Digital Cameras
Home Theatre
MP3 Players
Technology Content    
Kingston SSDNow V300 240GB SATA III SSD Review
Kingston SSDNow V300 240GB SATA III SSD Review
Aug 18 | Hard Drives/SSD
Seagate Backup Plus Slim External USB 3.0 2TB Hard Drive Review
Seagate Backup Plus Slim External USB 3.0 2TB Hard Drive Review
Sep 21 | Hard Drives/SSD
Waterfield Designs Muzetto Leather Notebook Satchel Review
Waterfield Designs Muzetto Leather Notebook Satchel Review
Aug 05 | Notebooks
Beginners Guide: How To Install / Remove an Intel Socket LGA2011 CPU
Beginners Guide: How To Install / Remove an Intel Socket LGA2011 CPU
Aug 14 | Beginners Guides
Beginners Guides: 99 Performance Tips for Windows
Beginners Guides: 99 Performance Tips for Windows
Feb 25 | Beginners Guides
Beginners Guides: 99 Performance Tips and Tweaks for Windows
Beginners Guides: 99 Performance Tips and Tweaks for Windows
Feb 25 | Beginners Guides
Newest Update! Take control of Windows with help from PCSTATS. We've got 99 ways to squeeze out better performance, enhance boot times, free up hard drive space and trim away Windows's fat.
Beginners Guide: Hi-Resolution Panoramic Images with MSFT ICE
Beginners Guide: Hi-Resolution Panoramic Images with MSFT ICE
Jan 27 | Beginners Guides
Microsoft Research has developed a free program called Image Composite Editor - which is a really powerful, but simple to use and nearly completely automated panoramic image stitching program that works with photos or video!
Samsung ATIV Book 9-Lite NP915S3G-K01 13.3-inch Touch Screen Notebook Review
Samsung ATIV Book 9-Lite NP915S3G-K01 13.3-inch Touch Screen Notebook Review
Dec 23 | Notebooks
Samsung's ATIV Book 9-Lite slots in somewhere between mainstream laptop and tablet on steroids, though at first glance it looks unassailably like an Ultrabook.
MORE » Complete PCSTATS Article and Review Listings...

The best Guides by the best writers on the internet; PCSTATS Beginners Guides explain computers, software, and all those other wonderful things that cause you frustration.

Learn how to use your computer better, master the internet while protecting yourself, and know what to do when your hard drive kicks the bucket.

  1. 10 Steps to a Secure PC
  2. 101 Tips and Tweaks for Windows XP
  3. 104 Killer Tech Tips for Windows XP
  4. 99 Performance Tips for Windows XP
  5. 99 Windows Vista Performance Tips
  6. Annual PC Checkup Checklist
  7. Assembling Your Own PC
  8. Back up and Restore Data in WinXP
  9. Browser Hijacking and How to Stop it
  10. Building a Home Theatre PC / HTPC
  11. Burning CDs and DVDs
  12. Cloning WindowsXP
  13. Converting Videotape Into Video Files
  14. Crash Recovery: The Blue Screen of Death
  15. Creating a Weblog / Blog
  16. Creating MP3 Music Files
  17. Decrypting Lost Document & Zipped File Passwords
  18. Diagnosing Bad Hard Drives
  19. Diagnosing Bad Memory
  20. Downgrading Windows Vista Back To Windows XP
  21. Dual OS Installation of WindowsXP 32-bit/64-bit
  22. Encryption and Online Privacy
  23. Ergonomics & Computers
  24. Flashing a Video Card BIOS
  25. Flash Memory Data Recovery and Protection
  26. Firewalls and Internet Security
  27. Firewall Setup and Configuration
  28. Forgotten Passwords & Recovery Methods
  29. Formatting and Partitioning a Hard Drive
  30. Fundamentals of Upgrading a PC
  31. Hard Drive Data Recovery
  32. Home Networking and File Sharing
  33. How to Install: Intel Socket 775 CPU and Heatsink
  34. How to Install: Intel Socket 1366 CPU and Heatsink
  35. How to Install: Intel Socket 1155 CPU and Heatsink
  36. How to Install: AMD Socket AM3 CPU and Heatsink
  37. How to Install: AMD Socket FM1 CPU and Heatsink
  38. How to Fix Homesite Design Mode to Work in WindowsXP/ Vista
  39. How To Make a Budget Desktop Computer on the Cheap
  40. How to Update a Motherboard BIOS
  41. Installing RAID on Desktop PCs
  42. Installing Windows Vista
  43. Installing Windows XP
  44. Internet Connection Sharing
  45. Legally Copying Software and Music
  46. Linux Part 1: Getting Familiar
  47. Linux Part 2: Installing a PC
  48. Linux Part 3: New Software
  49. Little Known Features of WindowsXP
  50. Making Old Software Compatible with Windows Vista
  51. Making DVD Movies from Video Files
  52. Most Common Ways to Kill a PC
  53. Optical Drives & Recording Formats
  54. Overclocking the CPU, Motherboard & Memory
  55. Overclocking the Videocard
  56. Preventing Data Theft from a Stolen Laptop
  57. Printer Sharing on a Home Network
  58. Quick Guide for Eliminating Spyware and Hijacker Software
  59. RAM, Memory and Upgrading
  60. Registry: Backups, Repairs, and Protection
  61. Remote Access to Computers
  62. RSS Feed Setup & Subscriptions
  63. Safe Mode in Windows Vista For Crash Recovery
  64. Setting up an FTP Server in WinXP
  65. Slipstreaming WindowsXP with Service Pack 2
  66. Spyware Protection and Removal
  67. Stopping Spam
  68. Stopping Vista From Thrashing Hard Disks to Death
  69. Synchronizing Files and Folders
  70. Unattended Windows 2000/XP Installations
  71. Understanding & Creating Batch Files
  72. Understanding & Tweaking WindowsXP Services
  73. Upgrading A Motherboard Without Reinstalling
  74. Upgrading Win98 to Windows XP
  75. USB Memory Drive Projects & Tips
  76. VPNs and Internet Connection Security
  77. Website Hosting From A Home PC
  78. Website Hosting With Apache
  79. Windows Vista Crash Recovery and Repair Install
  80. Windows XP Command Prompt
  81. Windows XP Safe Mode Explained
  82. Wireless Home Networking
  83. Wireless Network Security
"Get the 'Stats and Stay Informed!"

Frostytech's Top 5 Heatsink Comparison Charts

Recommended Tech Resources:

The PCstats Forums
PCstats Network Features Information About Us Contact
PCSTATS Newsletter
ShoppingList Assistance
Tech Glossary
Technology WebSite Listings
PermaLink News
Archived News
Submit News (Review RSS Feed)
Site Map
PCSTATS Wallpaper
About Us
Privacy Policy
Advertise on PCSTATS

How's Our Driving?
© Copyright 1999-2020 www.pcstats.com All rights reserved. Privacy policy and Terms of Use.