Emidor

Maurer's Music Mayhem

Excel workbooks opening slowly on the network

December 14th, 2012

excel_logoAfter a server upgrade at work, Excel, my favorite program, began talking a very long time to open files on the network storage. Files that used to take 3 or 4 seconds to open were now taking more than 2 minutes. If I moved the file to my local drive, the file would open immediately, as expected.

I am running Windows XP and Office 2003. Our server was updated to a SBS 2011 machine.

After doing a number of Google searches I found the following articles which helped resolve my problem. So I’m passing these tips on to help others who might be experiencing the same issue.

http://support.microsoft.com/kb/2570623
http://support.microsoft.com/kb/833041

Both of these articles have a FixIt utility that will make the appropriate entries in your registry to fix the “open latency issue.”

Hope this helps 😀

I Heart Excel

December 11th, 2012

As an accountant, I use Excel on a daily basis. As far as I’m concerned, it is the best piece of software ever written. This is just one of the views I see from my desk on a daily basis. Those graphs are an amalgamation of data from various spreadsheets and locations.

The Black Box

December 6th, 2012

This nondescript looking box was the cause of much consternation and frustration yesterday.

The swap to our new server at work was supposed to be seamless. I never plan on a no-trouble install. But I definitely thought it would go smoother than yesterday. End result, we have another day of work to make us wholly functional before I can retire the old server.

Day 6 of 25 days of photo blogging

Palm OS & Windows 64-bit

October 24th, 2012

Jen and I are avid GeoCachers. We download between 200 & 500 geocaches in a pocket query and then load those onto three GPSrs and a Palm Tungsten E. This gives us ultimate capability with no paper. These devices work much better out in the woods where there is no cell phone service than our smart phones.

I upgraded my computer this week to a 64-bit Windows Pro machine. There are updated apps and drivers for all my utilities and programs EXCEPT my Palm. ARGH!

So, after a bit of searching on Google, I find Aceeca, a New Zealand based company that uses Palm in their rugged barcode and RFID scanners. And they have built drivers for 64-bit machines to use the PalmOS!

A few mouse clicks later, my Tungsten is back up and running using data from my 64-bit machine.

Man I love technology!