Hi kishore this is Sai. I like to work more time on excel using forms and macros i have one doubt in my workbook contains number of worksheets all work sheets are same format daily our associates enter data in their respective sheets i mean updated sales information daily from different places (this file is using on Sharing ). now i want to get all data in one sheet in the same workbook and it should we updated automatically.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
First verify that no floppy
diskette or CD is in the computer, unless you are attempting to boot
from a diskette.
If not then it seems that your windows boot file got corrupted. all you
have to do is try using your notebooks recovery CD if you dont have a
recovery CD then you have to use the windows installer CD
1 Insert the Windows XP bootable CD into the computer.
2 When prompted to press any key to boot from the CD, press any key.
3 Once in the Windows XP setup menu press the "R" key to repair Windows.
4 Log into your Windows installation by pressing the "1" key and pressing enter.
5 You will then be prompted for your administrator password, enter that password.
6 Copy the below two files to the root directory of the primary hard
disk. In the below example we are copying these files from the CD-ROM
drive letter, which in this case is "e." This letter may be different on
copy e:\i386\ntldr c:\
copy e:\i386\ntdetect.com c:\
7 Once both of these files have been successfully copied, remove the CD from the computer and reboot.
Else you have to format your computer and reinstall windows again
Is that helpful
Go to the transcend site. In the support section, click drivers/downloads. Type in your model number or search for it. Mine was a Transcend 4GB JetFlash V10 drive. So the model number was TS4GJFV10. There will be a download called Recovery Tool. Get it. Run it. That's it.
P.S: use the global download link, its faster.
This one is a little hidden, it's an option under the save as window. So go to file->save as then you should see either a down arrow on the save button, which opens up a sub menu or a tools option in the top right. Under tools select general options, then you should see the password options there.
I am using MS-2007, i got the solution upto some level only.
i can't say exactly whether it is right or not.
my solution is :
first change the settings in ControlPanel/Regional and Language Options. Click on Customize button/open the Date Tab and set the date format there. and then proceed with CSV. Open CSV in Excel and divide Text to coloumns. Ur all Date Cells will be in particual Format. and Select that coloumns and right click Format Celss....etc. Thanking u.
If u found any Douts, Suggestions ,Plzz let me know.
If you right click the cell in question and go to Format Cells..., on the protection tab there should be a check mark in the locked box. Go to the tools menu and choose Protect and Protect Sheet, enter a password and your cells will be protected.
Any cells you want to allow changes to when the sheet is protected should have the Locked checkmark removed.
You will need recovery software to recover password for the protected files here is the link link1 Excel Password Remover 2008 -------------------------------------------------------------------------------------------------- Low feed backs hurt my ratings and I tried my
level best to resolve the issue. so please show your appreciation by rating it. Thanks for using fixya support..You have a wonderful day
With THIS program you can recover your password click here to download the software.. All the Best. Was this solution helpful? Show your Appreciation by rating it and if your problem is solved. Please vote …… FIXYA..