770 going weird

Many businesses use Excel to track their data and expenses.
However, you can run into problems when files grow too big.
Try reducing the size of your Excel files in different ways to eliminate your storage problems.
Remove unnecessary graphics and fonts from the Excel file.
Simple report data doesn't need a lot of excess formatting to make it attractive.
If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
Reduce the number of pivot tables you allow in your data analysis.
Run your pivot table wizard when dealing with involved calculations.
When given options to format the file, choose those that allow the data to refresh instead of adding a new table.
Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
To do this, choose "XML Data" in the "Save as type" drop down box.
Change the name of your document as well, so you can tell the difference between the two files.
Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
Check into file compression software such as OzGrid.
These products exist because you cannot open a file once it gets too big.
Compress the XLS data by compelling the program to recalculate the cells used for your file.

Excel File Size Reduce Software 7.0
http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html
http://www.ozgrid.com/

or

Microsoft Excel files can contain thousands of cells filled with data.
When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

1. Click on any cell in the Excel file you want to reduce.
Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
2. Click the "Special" button on the "Go To" dialog box.
Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


3. Go to the very last cell containing data in the Excel file.
Select the entire row beneath this cell by clicking the number to the left of it.
Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
The file size will be listed on the "General" tab.



http://www.ozgrid.com/Excel/ExcelProblems.htm

Many businesses use Excel to track their data and expenses.
However, you can run into problems when files grow too big.
Try reducing the size of your Excel files in different ways to eliminate your storage problems.
Remove unnecessary graphics and fonts from the Excel file.
Simple report data doesn't need a lot of excess formatting to make it attractive.
If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
Reduce the number of pivot tables you allow in your data analysis.
Run your pivot table wizard when dealing with involved calculations.
When given options to format the file, choose those that allow the data to refresh instead of adding a new table.


Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
To do this, choose "XML Data" in the "Save as type" drop down box.
Change the name of your document as well, so you can tell the difference between the two files.

Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
Check into file compression software such as OzGrid.
These products exist because you cannot open a file once it gets too big.
Compress the XLS data by compelling the program to recalculate the cells used for your file.


Excel File Size Reduce Software 7.0
http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html
http://www.ozgrid.com/
or
Microsoft Excel files can contain thousands of cells filled with data.
When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

1. Click on any cell in the Excel file you want to reduce.
Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
2. Click the "Special" button on the "Go To" dialog box.
Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


3. Go to the very last cell containing data in the Excel file.
Select the entire row beneath this cell by clicking the number to the left of it.
Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
The file size will be listed on the "General" tab.



http://www.ozgrid.com/Excel/ExcelProblems.htm

1 - Using "Open and repair"

Microsoft Excel has a built-in repair tool for corrupted files. To access it, go to File and Open. A menu will pop up in which you'll have to select the file you want to fix and then choose "Open and repair" from the dropdown menu. This will open a dialogue box in which you can pick between the repair option (which will recover as much information as possible) and the extract option (that will copy values and formulas). The two alternatives combined should work fine to save your work.

2 - Saving the file to a different format

If you can open the file but you can't modify it or save the changes, you should use this method. You'll have to save the file to a different format (such as SYLK or HTML) via the "Save as" menu. Once you've done this, you'll have to open the recently saved file and then save it once again (but this time, you'll have to choose the Excel Workbook as the format). By doing this, you'll be creating a fresh new file with all the data from the corrupted file.

3 - Opening the file in Microsoft Word

This option is only available for the people that have the Microsoft Excel converter installed on their PC (it can be downloaded from the Microsoft website). You simply have to open the corrupted Excel file with Word. However, you should know that this method only works for retrieving data (all the structures from the sheet will be gone, such as formulas and macros).

4 - Altering the Calculation option

If your file isn't opening at all you can try to adjust the calculation option. Simply open Excel in a blank workbook, go to the "Tools" menu and look for "Options". There you'll find the "Calculation" tab in which you'll have to look for the "Calculation" section and set it to "Manual". Click OK and then try to open the corrupted file once again.

5 - Linking the corrupted file

In this method, you'll have to link one cell of a blank worksheet to the corrupted workbook. Be sure to create the new worksheet in the same location as the corrupted file. Once you've done this go to the blank worksheet and enter the following in the A1 cell: <Filename>!A1. This will copy the data from the A1 cell of the corrupted file to the new sheet. In case it works, simply click "Edit" on the cell and select an area like the one covers the cell that contain data in the damaged file, and then click Paste. Then (and with the cells still selected) click Copy on the Edit menu.

Remove any memory cards that are in the phone (MicroSD, SD or MiniSD), and remove the SIM card, if your phone uses one. Make sure the phone is turned on before continuing (if you had to remove the battery to remove the memory card or SIM, turn the phone on).

Select "Contacts" from the main screen of your cell phone to access your contacts list. Go through the entire list, selecting each name and deleting the entry. Consult your cell phone manual to find out where the "Delete Entry" option is located in your Contacts menu (if you do not have a manual use the link in "Resources" to download a copy of one for your phone). Typically, when you choose an entry, the option to "Edit" will appear on the screen. Select that and one of the sub-options will be "Delete Entry." Do this for all of the entries in your Contact list.

Open your text messaging (SMS) application on your phone. Most phones have an icon you can choose from the main screen to go to the application (where you can compose, send, or read SMS messages). Press your "Menu" key again (or the key under the "Options" choice on the screen), and select "Delete All." Click on the choice to delete both read and unread messages. When you are done, return to the main menu.

Delete all of your media files. Go to your music, video, photo and MMS directories, and either use a "Delete All" option from the menu, or individually highlight each file name, select "Edit" and then "Delete" and remove each one.

Open your calendar and clear all of the entries. Make, sure when you choose this option from the calendar edit menu, that you check off the option to remove the calendar history as well, so past events are erased.

Open your email settings (where you entered your email address originally to receive notifications on your phone of new emails), and delete the email address you registered.

Open your notepad program and delete any notes you may have stored in the memory. Do this for any Voice Notes, if your phone offered this function as well.

1. make a sale entry in tally
2. Export the voucher from tally in xml format (this is to give u how the xml looks)
3. Open the excel file where all the data is ther.
4. open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility
5. in the XML which we did in step two, copy the data from "<TALLYMESSAGE xmlns:UDF="TallyUDF">" till the </TALLYMESSAGE>
6. Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher.
7. create the mail merge.
8. copy the data what you got in word file to a note pad and name it as sample.
9. open again the step 2 - copy data from " <ENVELOPE> to <REQUESTDATA>" and paste in the begining of the notepad sample
10. go the end of the notepad sample and copy the data from first file -"step 2" from " </REQUESTDATA> to </ENVELOPE>" and save the file
11. Open tally
12. go to import vocuhers
13. specify the path of the notepad sample and yes ur data got imported.

Solution 1.) If you have installed PDF maker, which can get installed when you install scanner software, the Excel add-on can potentially cause Excel to open slowly. This is more common in Office 2007.

* Close Excel and any other window you have open
* Open "My Computer" and browse to C:\Program Files\Microsoft Office\Office12\XLSTART
*

* When you open Excel, check to see if the time it takes to open the xls/xlsx is shortened.

Solution 2.) This can be fixed by reinstalling Office but there is a faster way to fix this .

* Go to your Control Panel, (click on Start then Click on Control Panel)
* Click on Folder Options, then File Types,
* scroll down to and select (DOC for Word files) or XLS (for Excel files),
* click Advanced and select Open entry,
* click the edit Button.
* deselect "Use DDE"
* append "%1" (include the quote marks) to the end of the application command line,
* Remove /dde if it is at the end of the command line
* Then click on OK three times.

If the issue was being caused by DDE, then when you now open a Word doc file or Excel els; they will now open faster, without a long pause.

how to remove the excel file security pass word


solution explain tel plz

Hello,

There could be 1 of 3 things affecting this:

1. Is another application using that excel document? If so you will not be able to edit it until the other application stops using it.

2. Is the file currently in a location that you do not have write permissions? eg. another users shared documents

3. Check in the properties to see if it is set to read only. (right click on the document and click properties. in the 'General' Tab see if 'Read Only' is checked. If yes, uncheck it and click okay)

An easy way to make it editable providing you are the only one using it (If the above fixes dont work) open it up in excel and then click File --> Save As... and then save it somewhere else. That will then make it editable for you.

Have a Great Day!

I will suggest you to create small application in .net for ths which will add some value and process your data;If you want to use Excel only make a master sheet with details and use it in other excel sheets

This is a "hosts" file problem, I was having the same problem.
To cure this I had to go into the Windows operating system files and manually change a system file, this is definately not reccommended if you don't know what you are doing.
This has been happening to me for several days before I edited the hosts file and now all is ok, I am sure it is a MSN glitch and they will sort it out. BUT unless you can get messenger to open messenger is not going to update and sort the problem out.
If you feel brave enough to attempt the edit, leave a reply.