Question about Microsoft Excel for PC

2 Answers

MS EXCEL 2000 corrupted workbooks/worksheets

Have 2 workbooks approx. 4MB ea with 4 & 5 lasre worksheets. Am experiencing "cancerous" symptoms, incl 1) formats change on own, expecially which cells or rows formats are applied to. Links among worksheets shift to different rows. Message "too many formats". periodic message that workbook cannot be saved due to internal errors. Program experences "Fatal Errors".
Workbooks ALWAYS opened and closed together.
Have tried "cleaning up" by moving select worksheets. all way to copying and pasting FORMULA then FORMAT to new workbooks.

Is there any way to eliminate these types of errors?

Posted by on

2 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Microsoft Master
  • 233 Answers

Checkout this globally used result oriented Stellar Phoenix Excel Recovery Software.
It can effectively repairs corrupted Excel files; fix damaged Excel files having .xls, .xla and .xlsx formats. It successfully repairs excel files that got damaged due to virus attacks, sudden system shutdown, storage media corruptions, bad sectors in the disk and even accidental file deletions.
Download the free trial version to see the preview of recovered data.

You can download this software from : Stellar Phoenix Excel Recovery

Posted on Dec 02, 2016

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 26 Answers

It sounds like you are going over the limits of the program these are the specs. I would recommend dividing up the data if you can. or moving it to a database that can act like excel and hold more data.

Posted on Apr 29, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

How Repair of Excel file?


If there was such problem, the simplest decision is described here:
http://www.excel.repair/ - Excel Repair Kit. A Microsoft Excel repair tool for corrupted Excel spreadsheets. Program open, read and save data from damaged Excel files.
If at you it didn't turn out to solve a problem, it is possible to try to solve it otherwise:
1. Click the Microsoft Office Button Office button image, and then click Open.
2. In the Open dialog box, select the corrupted workbook that you want to open.
3. Click the arrow next to the Open button, and then click Open and Repair.
4. Do one of the following:
3. To recover as much of the workbook data as possible, click Repair.
(a) To recover as much of the workbook data as possible, click Repair.
(b) To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.

Oct 17, 2015 | Computers & Internet

Tip

How to password protect Microsoft Office Excel 2003


Excel, a part of the Microsoft Office suit, offer password protect feature to prevent unauthorized users from viewing or modifying a *.xls (Microsoft Excel) file data, we can password protect MS Excel 2003 files so that only certain people can control the information.

Before Excel 2003 password protecting, here are a couple of notes:

1. Before password-protecting a workbook or worksheet, you have to consider writing down the password and keep it secure. That way, if you lose or forgot the Excel password, it will be easier to recover the information.
2. Excel has two types of password. One is "password to open" and the other one is "password to modify". You can password-protect the worksheet against modifications so that give some people read-only access to a workbook, or you can password-protect the workbook against opening an entire workbook of multiple worksheets.
3. Microsoft Excel supports several types of encryption settings, including Microsoft Base Cryptographic Provider V1.0, Microsoft DH Schnabel Cryptographic Provider, Microsoft Strong Cryptographic Provider, and more. However, password protecting an Excel file does not 100% guarantee that the password can not be decrypted or the password hacked. You can learn more about how to recover Excel password from SmartKey official site.

Now follow these steps to password-protect Excel 2003.

Step 1: Save your *.xls Excel file
Point to the File Menu, click save as and input the file name then the *.xls file is saved on your local disc. Point to "Tools" - "Options". When the "Options" multi-tabbed dialog box appears, click the "Security" tab.
amenchan.jpg
Step 2: Choose the password protect type
  • If you don't wish other users to view your Excel workbook, enter a password in the "Password to open" box, and then click OK.

  • If you agree other users to view your Excel workbook but don't want them make changes to the workbook, type a password in the "Password to modify" box.

  • If you wish to use a different encryption settings type, click Advanced, choose an encryption setting type you want in the list, and then click OK. And you can also specify the number of characters in the Choose a key length box.
amenchan_0.jpg

Step3: Confirm your password
After type your password, a "Confirm Password" box will prompted, retype your passwords to confirm, then click OK.
amenchan_1.jpg
Step4: Resave the Excel spreadsheet.
After password protecting your Excel file, click Save. All the steps are finished.

Tips:

All the original articles are authorized by SmartKey, welcome To Transshipment but Please Retain the original.

If you are interesting in Excel Password Recovery, please visit our website.

on Dec 20, 2010 | Computers & Internet

2 Answers

Excel Corruption files


Without seeing the file, it is difficult to diagnose what is going on, but I will offer some ideas.

What version of Excel are you using? Are you using Excel 2003? Was the file you are trying to open created in Excel 2007 or Excel 2010. If so, it might be using the new format and therefore will not open in Excel 2003 and older.

It is possible the Excel file is data that was imported from a source in which Excel cannot import. Does the Excel spreadsheet contain any imported data?
Try to use: XLSX Viewer Tool here : http://www.xlsx.viewertool.com/
Those are the most likely causes of the corrupt data. Is every file you open in Excel corrupt, or just this one workbook? If it is just this one workbook, then, yes, it sounds like it is corrupted. If every file you open with Excel is corrupt, then your version of Excel could be corrupt, but that is unlikely.

Jul 10, 2015 | Microsoft Excel for PC

3 Answers

Excel workbook error


I came across this issue today. An update to the Office Compatibility Pack that was still on a computer caused the default PROGRAM for .docx and .xlsx files to be the Microsoft Open XML Converter program and make the "Default Programs" in Control Panel think that Excel and Word were actually the Microsoft Open XML Converter scholarship essay writing assistance program as well.UNINSTALLING the Office Compatibility Pack in Programs and Features and then a simple reboot fixed the issue.
Also:
1: Try to repair it manually when MS Excel does not automatically STARTS File recovery mode.
Click the Microsoft Office Button, and then click OPEN.
Now select the corrupted workbook that you want to open.
Click the arrow NEXT to the Open button, and then click Open and Repair.
Choose either Repair (to recover as much of the FILE data) or Extract data (to extract values and formula when repair process is not successful).
2: Open with Open Office: Try to open your Excel file in Open Office. It is an open-source Office suite that is able to open & SAVE Microsoft Excel files.
3: Save in HTML Format: Open your Excel file and save it in HTML format. By saving the workbook in HTML format, you may be able to filter out the corrupted elements.
4: Save in SYLK Format: Open your Excel file and save it in SYLK format. By saving the workbook in SYLK format, you may be able to filter out the corrupted elements.
5: Try 3rd party software like Excel Repair Toolbox
link: https://www.repairtoolbox.com/excelrepair.html

Jun 18, 2015 | Microsoft Office Excel 2007

2 Answers

Excel 2007 document recovery repeating document on Terminal Server


MS Excel File can get corrupted due to virus attack, missing MS office files, power failure and other possible reason that can be fixed by only use Stellar Phoenix Excel Recovery fix corrupt Excel (.XLS/.XLSX) files and restore everything (including charts, chartsheets, cell comments, worksheet properties etc.

Jan 04, 2015 | Microsoft Excel for PC

5 Answers

Corrupt excel 2010 file


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.

Jan 23, 2013 | Western Digital Corporation WD ShareSpace...

5 Answers

Excel sheet has been lost how to recover


Lost Excel file can be recovered from:
  1. Recycle Bin - If you have deleted the file with normal delete.
  2. Backup - If have maintained the backup of file.
  3. Email - It may possible that you have mailed the file to someone.
  4. 3rd Party Recovery Software - Recuva, Stellar Data Recovery ...

Oct 29, 2012 | Microsoft Office Excel (License Only)...

2 Answers

What is a workbook?


A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheet

The term spreadsheet is often used to refer to a workbook, when in actual fact, spreadsheet refers to the computer program, such as Excel.

So, strictly speaking, when you open the Excel spreadsheet program it loads an empty workbook file consisting of three blank worksheets for you to use.


Jun 25, 2011 | Microsoft Office Excel 2007 Full Version...

1 Answer

HOW DO I ADD TABS TO MY SPREADSHHET IN MS WORKS


I do not think that works contains tabs. Microsoft Excel which is part of the office suite has what is known as a workbook and each workbook has individual worksheets that contain tabs along the bottom of the workbook. You can add new tabs there by right clicking and selecting insert and then select worksheet. You can also rename the tab with the right click option as well. These instructions are for microsoft excel 2003.

Aug 02, 2009 | Dell Computers & Internet

1 Answer

HOW CAN I MATCH THE TWO WORKSHEET FOR RECONCILIATION


Try this:
1. Find the copy of the workbook on which you will merge the changes. In Excel, go to "File > Open" and find the file.
3. Click "Tools > Compare" and "Merge Workbooks." 4. Look for the files you want to merge and add them into the current file. 5. Click “OK” to merge the files. This is your master copy of this workbook. 6. Save the file.

Dec 21, 2008 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

Not finding what you are looking for?
Microsoft Excel for PC Logo

278 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18344 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...