Question about Computers & Internet

2 Answers

Excel takes upto 1 min to open files, however if i click on the minimise button the file opens?? This is 2007 but also opening 2003 files.

Posted by on

Ad

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.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 977 Answers

Hi!

The problem you describe usually happens when a process gets "hanged" while opening a MS Office application.
Open the Task Manager and see if there's any process consuming a suspicious amount of CPU usage while opening the Excel document.

Waiting for your reply.
Even if it's not the issue, I might have some further steps for you to try...

BTW, is it a shared document (i.e. handled by different users over a network)??

Best regards,
Pelu.

Posted on Apr 23, 2010

Ad
  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 3,153 Answers

I use excel from office pro upward.

I do notice a little longer to open on the newer versions compare to office pro.

There are a lot of factors involved that could cause delays.

First off MACROS. These can cause delays if you have any set up no matter what the version as there are security aspects involved.
IF you do have macros but don't use them or pass the sheets to people that don't use them then remove those.

A large factor with big sheets is the computer specification that is running office. This is one of the more noticeable aspects. A slow computer with limited ram can be very slow.
More so if there are too many other processes / programs running.

Quite often I can speed such computers up by performing a very thorough clean up before continuing to use office

Additionally there can be delays when using sheets between version of office as office 2007 tends to save with features not all versions of office support.
The general fix for that is to ensure that the office compatibility pack is installed on ALL computers and where possible save the sheets on the lowest version of office you have.

Another important issue is to ensure that the computers you use are virus AND malware free.
This can be quite important especially if you DO use macros !

LAST but not least it is not uncommon for an office installation to become corrupt either by accident or incorrect shut down etc.
In those instances a "repair" installation will quite often fix things.

If a file is corrupt and is used on anther computer it is possible for it to carry those settings to the next computer. This can happen more with word documents where a layout profile may be carried over.

I know there appears to be a lot to look at here and there are a few more odd issues that could also give you the problems you see but these are the most common ones

Hope this gives you the information you need

Bob
Moderator

It would be very decent of you to consider the quality of our experts answers and judge them accordingly as you pass through FixYa.

Thank you

Posted on Apr 23, 2010

  • Project NOMAD
    Project NOMAD Apr 24, 2010

    did you get any further ?

×

Ad

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

1 Answer

Excel 2003 worksheet slow in 2007


Hi Lee, I have recently experienced the same thing. When Excel 2007 or later opens an Excel 97-2003 .xls file, there are major issues of speed. The file is opened in compatibility mode. The best thing to do would be to open the file, then save as (keep the same name if you like) an Excel 2007 .xlsx document (or .xlsm document if there are macros). Close the file, then reopen it, and the compatibility mode issue will be gone. You can now use the newly saved file as a normal Excel 2007 file. Hope this helped.

Mar 25, 2014 | Microsoft Office Professional 2007 Full...

8 Answers

I cannot open .docx and xlsx files.


The files extensions you have listed, .docx and .xlsx, are files that have been created using the Microsoft Office 2007 or 2010 suite of programs. Specifically .docx is a Microsoft Word document, and .xlsx is a Microsoft Excel spreadsheet. You will have to have either of the Microsoft Office programs mentioned, or you can also use the Open Office suite of programs. This is a free program that you can download at the following website:

http://www.openoffice.org/

Mar 05, 2011 | Microsoft Windows XP Home Edition

4 Answers

How to convert 2007 excel sheet into 2003 excel sheet


if you have excel 2007 you can save the file into excel 2003 compatibility

if you have excel 2003 need download compatibility pack from this page
http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
install it and success!

Feb 22, 2011 | Computers & Internet

2 Answers

How to Open the Excel file 2003 in Office 2007?


You have to download this compatibility pack and instal it on your machine. Here is the link.

http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

Jan 03, 2011 | Microsoft Office Professional 2007 Full...

4 Answers

Solution for Excel 2003 "the file is not in a recognizable format"


If you open an excel created by M/S Office 2007, Excel 2003 will not be able the file. You have to install Microsoft Office the "Compatibility Pack for Word, Excel, and PowerPoint File Formats" for M/S Office 2003 from Microsoft Site.

or

Your Excel file is corrupt!

Hope it helps.


Oct 01, 2010 | Computers & Internet

2 Answers

How to convert excel 2007 to 2003


With Excel 2007, open the spreadsheet.
Click File
Click Save As
Choose to save the file in the "Excel 2003" format.
Choose a filename.
Click Save.

Aug 19, 2010 | ScanSoft PDF Converter Professional...

2 Answers

My file is in excel 2007 i want to open in excel 2003 how would it happen or not


open the excel 2007 file in excel 2007 only and save as file.xls[xls is a 2003 version]

with this method u can open it though excel 2003
any issues kindly rate and revert

Jul 14, 2010 | Microsoft Excel 2007 Home and Student...

1 Answer

A 2 MB xlsx file is taking long time to open and save - consuming 50% of CPU - making Excel screen go white - using 55 MB RAM - auto calculation off - any ideas to resolve this


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.

Aug 14, 2009 | Microsoft Office Excel 2007

2 Answers

Word & Excel won't open files when doubleclicked in Windows Explorer


In Microsoft Excel 97, on the Tools menu, click Options. Click the General tab. Clear the Ignore Other Applications checkbox, and click OK.
In Excel 2007, Click Office Button, Excel Options, Advanced.
Look for General.
Clear the Ignore Other Applications checkbox.
Now, as to why this was checked in the first place, ewan ko na!

Dec 19, 2008 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

17 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

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

Answer questions

Manuals & User Guides

Loading...