Sunday, 31 January 2010

Excel 2007 can't open any files unless you use the 'File' --> 'Open' menu:

Problem:
When trying to open a file using any method other than the office button in Excel itself it tells you that it cannot find the file. So, if you double click an Excel file, Excel loads then shows a pop-up saying 'Windows cannot find make sure you typed the name correctly and then try again.' Same thing happens if you use the recent start menu item in Vista. Only if you use the office button in Excel to open a file does it work.

Solution:
Check under Excel Options, there is an option in the advanced section called 'Ignore other applications that use Dynamic Data Exchange (DDE)' - make sure this is NOT checked.

How to use VESA modes within Linux:

Although the Linux kernel allows user configuration of VESA modes at boot time using the 'vga' kernel parameter. This parameter does not directly accept VESA video mode numbers; instead, a Linux video mode number must be calculated using the VESA number.

To calculate the Linux video mode number add 512. The resulting decimal value can be passed to the kernel in the form 'vga=XXX', where XXX is the value. This calculation is not always accurate. It is a good starting point and you may have to do some experimenting to find the correct value.

How to enable Plymouth's graphical boot on Fedora with a 1680 x 1050 monitor:

Problem:

You want to enable the graphical boot available on Fedora 10 and above but you have a 1680 x 1050 monitor.


Solution:
The Linux video mode number you need to enable graphical boot with Plymouth using 1680x1050x32 is 'vga=873', this converts to VESA mode '369'.

So type the following into the terminal to configure grub:

su - nano /boot/grub/grub.conf

Then, within the grub.conf file, add the 'vga=873' at the end of the line starting 'Kernel' after the word 'quiet'.

Then 'Ctrl O' to save the changes and reboot.