Calculate Worksheet or Workbook Manually

Press F9 - Calculates formulas that have changed since the last calculation and formulas in all open workbooks.

Press SHIFT+F9 - Calculates formulas that have changed since the last calculation and formulas dependent on them in the active worksheet.

Press CTRL+ALT+F9 - Calculates all formulas in all open workbooks since last changed.

Press SHIFT+ALT+F9 - Rechecks dependent formulas and then calculates all formulas in all open workbooks since last changed.

By default it should be auto re-calculating.

Excel 2003 Formula Wont Update / Refresh

Please follow the path to turn on the "Automatic" options in Microsoft Excel 2003.

Tools > Options > Calculation (tab) and ensure the "Automatic" options is tick.

Windows found that this file is potentially harmful. To protect your computer, Windows has blocked access to this file.

Windows found that this file is potentially harmful. To protect your computer, Windows has blocked access to this file.

To open the file, please follow the instructions given;

1. Right-click the file (ex: Setup.exe) then click Properties
2. Click the Unblock at the bottom of the box
3. Apply and ok
4. Now you can try run the setup file again, by right it should work....

OS: Windows XP sp2

Vista Patch for AutoCAD 2007

Just know a friend call up, asking me whether this AutoCAD 2007 can operates on Windows Vista and suddenly i realize i dun have that informations so i Google it and finally found the solution. Maybe this will useful so i post here.

Please update AutoCAD 2007 with SP2 in order to work on Windows Vista. Autodesk has released SP2 for AutoCAD 2007. Here is the link to download SP2

Source: Autodesk

AutoCAD 2007 Service Pack 2 for Autodesk AutoCAD Revit Series—Building 9.1

Published date: 2007-04-19 ID: DL9445054 Applies to: AutoCAD® 2007 Autodesk® AutoCAD® Revit® Series—Building 9.1

autocad2007revits91sp2.exe (exe - 13139Kb)

This Service Pack addresses a number of issues and provides Microsoft Windows Vista support.

Microsoft Windows Vista Users

Due to a limitation in Service Pack 1 (SP1), Service Pack 2 (SP2) cannot be installed on Windows Vista with SP1 already installed. To install SP2, first uninstall and reinstall AutoCAD and then apply SP2 (without installing SP1).

Note: Apply this service pack only if you installed AutoCAD from the Autodesk AutoCAD Revit Series—Building 9.1 product.

OS: Windows Vista

Folder Options Missing

Symptom:

• Folder options is missing from the Windows Explorer Tools Menu.

Cause:

• Problem caused by Group Policy
  

Solution:

• Click Start, choose Run and execute Regedit
• Navigate to:

[HKEY_CURRENT_USER\Software\Microsoft\ Windows\CurrentVersion\Policies\Explorer]

• Look for a value called NoFolderOptions on the right panel
• Right click on the NoFolderOptions value and choose Delete
  
• Navigate to:

[HKEY_LOCAL_MACHINE\Software\Microsoft\ Windows\CurrentVersion\Policies\Explorer]

• Right click on NoFolderOptions on the right pane and choose Delete

OS: Windows XP

Preparing Zong for Duanwu Festival (Tuesday - June 19, 2007)

Source: Wikipedia

Model: Nokia N70

Duanwu Festival (端午節, Duānwū Jié) or Dragon Boat Festival is a traditional Chinese festival held on the fifth day of the fifth month of the Chinese calendar. It is also known as the Double Fifth.^{[citation needed]} It has since been celebrated, in various ways, in other parts of East Asia as well. In the West, it's commonly known as Dragon Boat Festival.

Zong, zongzi, or Chinese rice dumplings are a traditional Chinese food, made of glutinous rice stuffed with different fillings and wrapped in bamboo leaves. They are cooked by steaming or boiling. In Cantonese, these rice dumplings are called joong. In Taiwan, the Min Nan call them tzang. Laotians, Thais, Cambodians and Vietnamese also have similar traditional dishes.

As part of the Duanwu Festival for the next coming week, my sister had to prepared some Zong for the festival prayers and some offered to the ancestor and also giving out to friends and family as they together celebrate the festival.

Here are some pictures taken, show how my sister prepared the Zong;

Dried bamboo leaves

Cooked bamboo leaves

Glutinous Rice (Fried with thick soy sauce and 5-spice powder)

Peanuts without skin (fried without oil) and Black eye beans (soak)

Dried mushroom (cook with think soy sauce)

Fried Vegetarian Meat

Fried roasted pork and chau sau meat

First, take 2 pieces of bamboo leaves

Second, fold a V shape at end

Third, fill in some glutinous rice

Forth, put in some peanuts and black eye bean

Fifth, put in some vegetarian meat or pork meat

Sixth, put in some mushroom



Last, put in glutinous rice to cover up the top

Now, hold the top position of the leave and fold down to cover the filling

Hold and fold it nicely as this part the filling can easily come out

Hold it properly and fold the remaining to left or right

Okay, fold like this


Next, take a string and start tide the Zong

Round n round...

Now, make a ribbon-tied

Here you go, we are almost done

Finally, do some touch up, if not later the filling will come out

Tadaa.....done. The complete wrapping. Wow! Look nice.

Here are the completed Zong and ready send to boil

Now the Zong is ready to boil and it take about 6-7 hours cooking time

Zong is ready for serving

Ground peanut filling

Vegetarian and mix bean filling

Mix bean filling

Pork and mix bean filling

For the next few week, I guess we are going to have day and night Zong Menu, since my sister make so many. Hahaa. Bon Appetite

My '101 Mouse'

Model: Nokia 3230

Nice Handled Space Key-Chain

Model: Nokia 3230

Eco Toys

Source: Jenny (Birthday Gift, 2005)
Model: Nokia 3230




The head was moving like saying 'YES' x 3 to you.

Acronis True Image 10.0 - Recover the entire hard drive contents

Prerequisite:

1. Acronis True Image 10.0 installed on the system
2. Activated Acronis Startup Recovery Manager
3. Created a new full backup archive from first time Windows installation
   
4. Backup all necessary data on (C:) drive to other partitions or external drive
   

Note: (C:) drive contents will be restored back to where the first time full backup archive was created.


Step by Step:



Power on computer and when you see:

Starting Acronis Loader...
Press F11 for Acronis Startup Recovery Manager

Press F11 (Function Key)










On the Main Acronis Login screen, please select Acronis True Image Home (Full version)














Acronis True Image Home allow you to set password to security purposes.

Key in necessary password.












Acronis
Loading, please wait...














Acronis True Image Home Main Menu

Please select Recovery

Recovery: recover the entire hard disk contents or restore individual files.








Welcome to the Restore Data Wizard!

This wizard will help you to recover lost or corrupted files or entire partitions from the backup archive you have previously created.

Please click Next to continue.











Archive Selection:

Please select 'Acronis Secure Zone' in the tree and click Next to restore data that this archive contains.












Acronis Secure Zone Protection:
Acronis Secure Zone is password-protected

Please enter the password and click Next to continue.










Restoration Type Selection: You can select type of backup archive restoration.

Choose 'Restore disks or partitions'

Descriptions: Select this option if you want to restore a disk or partition entirely.

Please click Next to continue.








Partition or Disk to Restore:
Select a partition or a hard disk drive to restore

Please select/tick the 'Disk 1; (C:) drive partition; Flags: Pri Act' as shown in the picture

Please click Next to continue.








Restored Partition Location: Select a target partitions or unallocated space for the restore

Please select 'Disk 1; (C:) drive partition; Flags: Pri Act' as shown in the picture

Please click Next to continue.









Restored Partition Type:
Choose the restore partition type

Please select 'Active'

Note that original partition type is selected by default.

Please click Next to continue.










Restored Partition Size:
Specify the size and location of the restored partition

Leave default setting

Please click Next to continue.









Next Selection:
Would you like to restore another partition or hard disk drive from the backup archive?

Please select 'No, I do not' and click Next to continue.










Restore operations options:
You can set up restore options. Choose the category in the tree and set the options in the right pane.

Leave default setting

Please click Next to continue.










Acronis True Image is ready to proceed with restoring your data from the backup archive. Here is the complete list of operations to be performed.

Please click Proceed to start.