- open excel 2003
- click tools, then click options
- in the opened window, click calculation tab
- in there check under calculation, if your calculation mode set to manual, change it back to automatic mode.
- after change click ok
- now check your excel work sheet, the formulas work correctly.
Welcome to NSTECH blog, this site provides free IT Support for everyone, providing you informations about virus guards, system repair, system recover, tips and tricks, registry tweaks and more.
Thursday, July 29, 2010
excel 2003 formulas not working
when excel formulas suddenly stops working, the only place you have to see is excel options, to do this follow these steps,
Friday, November 6, 2009
create batch file for shutdown and restart
This will show you how to create batch file to shutdown or restart your pc, also you can schedule it by any given time, follow these steps.
Create batch file for shutdown (with shutdown message box)
Create batch file for restart
Create schedule for shutdown
Note - to immediately cancel shutdown or restart job, type shutdown.exe -a in run command and press enter.
Create batch file for shutdown (with shutdown message box)
- First create new text document
- Now inside text document type c:\windows\system32\shutdown -s -f -t 300 (the value 300 is 5 min, (60 x 5) if you want you can raise or reduce the value or put 00 for immediate shutdown)
- Now save the file as with the extension of .bat (ex- shutdown.bat)
- Important - make sure you uncheck "hide extensions for known file types" in folder option before naming the batch file. otherwise it wont create batch file,it will create only text file named as shutdown.bat.txt
Create batch file for restart
- First create new text document
- Now inside text document type shutdown -r -f -t 300 (if you want restart immediately without countdown set value to 00)
- Now save the file as with the extension of .bat (ex- restart.bat)
Create schedule for shutdown
- Open schedule task folder (start > run > type tasks > press enter)
- Double click add schedule task
- Click next
- Click browse button
- Specify the shutdown.bat file we created
- In the name field type anything, and select the action under "perform this task"
- Now proceed with the schedule task, and click finish at the end.
Note - to immediately cancel shutdown or restart job, type shutdown.exe -a in run command and press enter.
customize "send to" items in windows xp
You know you can customize "send to" menu and you can add more new destination in Send To lists. this can be done in a simple way, follow these steps.
- Click start, click run
- Type sendto and press enter
- This will open window with default Send To lists (Compressed (zipped) Folder, Desktop (create shortcut), Mail Recipient, My Documents)
- Now drag-and-drop any program, folders and drives, shortcuts to this folder
- For example - we take Microsoft word program, go to the program installation folder, find winword and drag-and-drop it to the send to folder
- Now to verify new location, right click on a text or a wordpad document, point to send to, click winword
- This will open the selected file with the Microsoft word
disable automatic update and service
If you want to disable automatic updates for windows you can do it by in control panel or system properties, but you know that even if you turn off updates in here automatic update service will continue to run in background. in order to disable this service follow these steps.
- Click start , click run
- Type services.msc and press enter
- Now find the automatic update service and double click to open it
- Now stop the service by pressing stop button under "service status"
- Then under "startup type" select disable
- Click apply and ok
restore missing tabs in "display properties"
In windows xp sometimes you notice that your "display properties" tabs were missing suddenly. (actually sometimes hides itself) such as "Themes , Desktop, Screen saver, Appearance, Settings" ,this can happen for many reasons, the exact cause for this is yet to be found, but we know how to restore the missing tabs in display properties, follow these steps.
- Click Start, click Run
- Type regsvr32 themeui and press enter
- Again Click Start, click Run
- Type regsvr32 /i shell32 and press enter
Friday, October 23, 2009
add more columns to task manager
You can add more column to process page of task manager, this ensures to view more running processes. in this example we gonna show you how to add "virtual memory size" to task manager process page.
- Press alt + ctrl + del to open task manager
- Now click on process tab
- Click on the view menu and click select column
- In the "select column" window select virtual memory size by checking the box
- Click ok
- Now you can see the new column named VM Size , in here you can identify how processes used virtual memory size for each process
disable auto reboot when error occured (blue screen)
This will show you how to disable automatic restart option in registry, follow these steps.
- Open registry editor
- Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\CrashControl
- In the right side double click AutoReboot key
- Change the value to 0 to disable and 1 to enable
- Exit registry editor and restart pc
windows low on registry space (win 2000)
The most possible cause for this is errors in windows partition, as a result of this error you cannot change the page file values. the first thing to try is using scandisk.
Solution
Solution
- Start command prompt
- Type chkdsk /f and press enter, this will ask to schedule scandisk in next restart, press y
- In the restart system will scan the partition you specified, after login to windows your problem will be fixed.
- Start > run
- Type regedit and press enter
- Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management
- In the right side open pagingfiles key
- The default registry value described in here, for example if you set initial size of 2046 and maximum size of 4092 for your pagefile, your registry key value should be C:\pagefile.sys 2046 4092
reduce the time of operating system selection menu
If your pc in a dual boot mode (such as xp and vista) you notice that every time you restart or switch on pc operating system selection menu is displayed, the default timeout is 30 seconds, if you want you can reduce default timeout. follow these steps.
- Right click on my computer and click properties
- Click on advanced tab
- Under "startup and recovery" click settings tab
- Now reduce the timeout by clicking the down arrow head in "time to display list of operating systems"
- After done click ok
- Then click apply and ok
- Reboot the pc and you can see the changes for default timeout
- Right click on my computer and click properties
- Click on advanced tab
- Under "startup and recovery" click settings tab
- In here under "default operating system" the first displayed operating system is the default highlighted operating system, to change the order click down arrow head and select the other operating system you prefer, after done click ok
- Reboot the pc to see the changes
to view hidden and super hidden files
To view hidden files in you need to deselect some options in folder option. note that most viruses hide itself for further infections and more damaged to your pc, when you enabled view hidden files option, you can safely delete those viruses, some viruses run itself as a active process, there for you may not be able to delete viruses easily. use runscanner utility to kill virus process. to view hidden files
- Start > run
- Type control.exe folders and press enter
- In the folder option window, click on view tab
- Under "advanced settings" select show hidden files and folders also deselect hide protected operating system files (recommend)
- Click apply and ok
Subscribe to:
Posts (Atom)