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