Whilst using MS Excel I noticed that the calculations were not updating automatically, I have never experienced this in many years of using this software.
Found the issue, under Formulas and Calculation Options just select automatic. I opened a pricelist spreadsheet from a supplier and somehow that may have changed the setting.
I know WHS2011 is out of date but it is too much work at the moment to install a newer operating system on my home server. I attempted to perform a windows update as I usually do, unfortunately, I received a red error warning Windows update cannot currently check for updates because the service is…
After new installation of Windows 7 folders and files were locked and admin permission was required even though account in use was admin. Work around: First switch of UAC – user account control. Technet forum Here’s how I edit the C:WindowsSystem32driversetchosts file. It gave “You don’t have permission to save in this location..” but I solved…
After reinstalling Windows on to my PC I noticed that I could not get Sage Line 50 2009 accounting software to load up sample or company data files. After searching I found that there is an issue related to the Windows 10 Anniversary updates. The fix is simple luckily, head over to Ask Sage and…
I have had this issue occur again in Windows 10, I am trying my original solution as I type this but there is another possible solution I found here Method 2 Go to Start menu button and right click on it. This will open the contextual menu, after which you need to select Command Prompt…
I had issues with HDD failure and standard backups were not ideal so I am trying Raid for the first time. I considered a controller card but my motherboard has raid built in. Go to bios (del), advanced>components> change to RAID for IDE SATA. Can be under Storage Configurations. Save and exit. The shortcut is…
Making a list of product SKUs, trying to avoid duplicates. Found this data validation post Click on Data tab>Data Validation Icon Click on the Allow: drop down and change to Custom In Formula field enter: =COUNTIF($A$2:$A$1500,A5)=1 A2 being the start and A1500 being the end of the list. Explanation: The COUNTIF function takes two arguments….