Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

Excel Wont Open. It Says It Needs To Install(?) Why? Word And P.

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

when I click on the excel icon a box comes up saying"preparing to install"
then it asks me to insert disk. I cannot find my discs!!! Why is it doing
this as i installed word excel and powerpoint together and the other 2 work

Please help!


View Answers     

Similar Excel Tutorials

Open Microsoft Word from Excel
This free macro will open the Microsoft Word program on your computer. You do need to have this program first. Thi ...
Open a Word Document from Excel
This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word ...
Extract a Word from a Sentence / Cell in Excel with this UDF - Allows for a User-Defined Delimiter
Extract whole words from a cell or sentence in Excel with this UDF. This allows you to specify which word from a c ...
Open any Program from Excel
This free excel macro allows you to open any program on your computer from excel. You can open a media player, fil ...

Helpful Excel Macros

Save the Current Worksheet as a New Excel Workbook File
- This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to a
Open Microsoft Word from Excel
- This free macro will open the Microsoft Word program on your computer. You do need to have this program first. This wi
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume
Open Microsoft PowerPoint from Excel
- This free macro will open the Microsoft PowerPoint program on your computer. You do need to have this program first. T
Macro to add a New Line to Message Box Pop-up Windows in Excel
- This is a very simple Message Box, pop-up window, macro for Excel that illustrates how to put new lines, the same thi

Similar Topics

Hi. Excel worked fine for two years then one day, whenever I launched Excel, a Windows Installer window popped up and the following series of messages are displayed: "preparing to install" then "Please wait while windows configures MicroSoft Office Basic Edition 2003" then "The future you are trying to use is on a CD-ROM or other removable disk that is not available. Insert the 'Microsoft Office Basic Edition 2003' disk and click OK"

Now, if I click CANCEL during these messages, Excel runs fine. The PROBLEM is when I am trying to IMPORT into Excel. The same series of messages starts and if I cancel, the import can not proceed. If I do not cancel, I reach a dead-end at the message that tells me to insert the disk.

My Dell computer came new with Excel loaded. Whether or not I received the Excel discs with the computer, I don't know... I certainly don't have them now.

Anyone know if there is a fix for this? Thanks much for any help!

I am getting so frustrated! I can not get the template with data tracking to
load. I have used my original Office ** to try to install it, but can not
get this to work. I click on tools, add-ins, and it keeps telling me its not
installed. so I say yes, install now. Says to insert disk so I put in **,
keeps asking me to find data1.msi file (which I select from browse) and it
keeps telling me thats not the right file. I feel like Im in an endless loop
and can not get this to work. Any help would be greatly appreciated!!

If I try to open a .csv in Excel 2000 I get an error saying the
converter isn't installed and it asks if I want to install it. If I
select yes then it says the converter can't be installed. If I select
no then the file opens up fine. So it appears to work fine so how do I
get it to quit asking if I want to install the converter?


For last few days everytime i open Excel 2010 it keeps trying to install Visual Studio 2010 Ultimate even through it is already installed on my PC.

When it is left to install it does not install it just produces a screen asking for a the Visual Studio 2010 disk to install the software.

Does anyone know why Excel keeps doing this?



when trying to insert a picture as an object without linking and not as an icon it doesn't matter what type of picture file i try to insert .bmp , .jpg the picture shows as an icon. the isnert picture as icon box is unticked. I found a temporary solution by converting the picture to a 24 bit bmp file but this as stopped working.
i'm using word 2003 with sp3 and office 2007 compatability pack installed .

can someone tell me how to get to see the picture i'mtrying to install rather than an icon.

I have:
XP Pro/SP1
Office 2000 SR-1 Professional

I have got some problems with Excel. When I click an XLS file I get
a message flash up and then vanish which says "Preparing To Install"
and then nothing else happens.

I can launch Excel by running the EXE direct. I still get the
message "Preparing To Install" but then Excel appears.

MS Word is ok.

I decided to do a repair installation. I put my original ** in the
** drive and clicked Add/Remove Programs > MS Office > Change. I get
a message saying:

"The installation source for this product is
not available. Verify that the source exists
and that you can access it".

I get the same message if I click "Remove" for MS Office.

And if I go to the ** and list the files and launch the SETUP.EXE
file I also get the same message. (This time the message box is
titled Windows Installer whereas before it was titles Add/Remove

How do I get around this to repair my Excel?

I downloaded and installed all the Service upgrades for Excel2000. Now when
starting Excel I get a message that data1.msi is missing and to put the
installation disc in the drive.

Problem is, I bought the computer with the software on board, and did not
get install/system software. I do have the product key. Can I get the
install software, online?

Mark Duncan


I have a free trial version of office 2007 installed on my computer and have the complete office 2003.

the trial version has expired and so opens files in compatibility mode - you cant edit them.

all of my excel files now open in excel 2007 for some reason whereas before they used to open in excel 2003. i want all my files to open in excel 2003. i have tried numerous things to achieve this.

i right click on the file i want to open, and select "open with", but when i browse files and select Excel from the folder "Office11" (the 2003 version) it never shows up on the list of programmes, it just highlights the 2007 version.

i have tried uninstalling the trial version of office 2007 but i receive a message which says i have to insert the original data source (or something along those lines) and it wont let me uninstall it. i have also tried deleting Excel from the folder "Office12" (the 2007 version) but then when i double click files after, it says "preparing to install" and wont open.

is there any way i can have all my documents open with excel 2003 rather than the trial version of excel 2007? Excel 2003 still works if i click on the excel 2003 icon on the desktop. so im having to first open excel 2003 and then open the file i wish to view, which is getting very annoying especially when opening excel attachments in e-mails, which i have to save first, then open excel 2003 and then open the file in there.

is there any other way that i can have all my files open with excel 2003? i have tried a number of things as described above but have had no luck so far...could there be some sort of technical problem with my computer?

any replies would be greatly appreciated...thanks.

When I try to open excel or go to an excel file, I get a pop up for windows
installer saying that it is preparing to install microsoft office 2000 sh-1
small business and asks me to insert the appropriate office 2000 disk (which
I don't have)
How can I eliminate this pop up? I have windows me


I've tried everything I can think of to get the "View Definition" icon/button to be active (not gray) with no luck. I looked at the install disc to see if it was an installation install, looked at all the settings and preference options, etc.
Example: I open Object Browser, type in "Range" to search for, click on Range, then one of its "members" (e.g., "EntireColumn" property) then - one would think, I could click on the "View Definition" icon at top to get details on this item. But its always grayed out.

Recently upgraded to Office 2007 (Windows XP Professional 5.1). With my prior version, I installed VBHTML Maker w/ no problems, an icon was placed on my menu, etc. Now, I've added it (as an add in) successfully but don't know where to go to actually make the application work. Again, before I would have the sheet open that I wanted to convert, I'd click the HTML icon and all worked fine. Now, I don't know where to go to get the that icon that converts my file.


I have a new laptop with Office 2003 Student Edition. I use Excel and Word
the most. I recently found the word merge portion of our Realtor MLS program
can not work with Word or Excel 2003. I have a prior version Office XP 2002
I can install. Will I be able to use all the Excel 2003 and Word 2003
documents if I uninstall 2003 and install Office XP 2002? I can't afford to
screw up 100's of Excel Spreadsheet work.



I am trying to insert a Word Object into Excel 2007. I go to the Insert tab, then select Object under the Text grouping. From the pop-up window I select Microsoft Office Word Document, click OK and then I get a small Word browser inserted into the Excel document with a new menu bar at the top. I click File at the top, then Open to open the word document I want to Insert. I Select the file, Click OK, and then get the error: " "FileName".docx : file format is not valid ". I have tried other Word files, as well as the older .doc type files, nothing seems to work. What am I doing wrong? Thanks.

I am trying to embed Excel .xls file objects that contain VBA code in pages of a .ppt file. Using the menus insert -> object -> from file.

This works fine if I use Powerpoint 2003, but when I try to use Powerpoint 2010 I can get the object inserted but when I try to edit it, I get the following errors:

First in Excel:
Error accessing file. Network connection may have been lost.

Then in PowerPoint:
Microsoft PowerPoint can't start the application required to open this object. An error occurred and this featue is no longer functioning properly. Would you like to repair this feature now? I click "no" as I know the function is fine.

then another PowerPoint error:
There isn't enough memory available to read Worksheet.

The files are stored on same disk drive.

My troubleshooting so far:
I have set all macro security for both Excel and Powerpoint 2003 and 2010 to none. I have checked any boxes that state trust VBA objects. If I insert the .xls object using PowerPoint 2003 on another system and then re-open the ppt file using 2010, I can then edit the .xls object. If I convert the .xls file to .xlsm, then insert, it will work fine. PowerPoint 2010 can insert and edit .xls objects that do not contain VBA code. I set the references in the Powerpoint VB editor to include Excel object library, no change. I have installed 2003 on the same system as 2010 (Win 7), and it will not work then, even in the 2003 applications. I have installed 2010 on the Win XP system and it did not work there either. I tried dragging and dropping the xls file onto the ppt page, that results in 7 of the 'Error accessing file. . ' messages before it inserts the object. If I insert the object in 2010, then try to edit the object on the 2003 system, I get the same edit errors. I can create a new Excel 97-2003 worksheet object, then add a macro to it after it is inserted and it will edit fine. It only errors when inserting from file. To reproduce the problem, open/create a powerpoint file (can be ppt or pptx). Then insert any xls file that contains some VBA code. Insert the file as an Excel 97-2003 worksheet object. After the object is inserted, select to edit the worksheet object. That is when the errors will occur.

Windows 7 system details:
OS - Windows 7 64-bit
Office ver - 2010 Professional Plus
Intel core2duo cpu
4GB ram

Windows XP system details:
OS - Windows XP Pro SP3
Office ver - 3002 Standard Edition SP3
Virtual machine on Oracle VM VirtualBox

Any help is greatly appreciated.


I'm trying to install the Solver add-in in a trial version of Excel 2007. When I try to install I get an error message stating that Excel cannot access the file solver.xlam. The various reasons given (file does not exist, file being used by another program and file is being saved to same name as currently open workbook) do not apply.

I've tried a repair and run the diagnostics, but still can't install. The Analysis Toolpack add-in installed without any problem.

Any suggestions?

Hi all,
this problem might be 2-fold.

I start excel both from an existing file, start menu and within explorer. It tries to install it again, asking for a cd. All other microsoft apps are working.
This only started today and their has been no indication that there was a problem with excel before.
Secondly, last week I had a problem with outlook and word. Outlook couldnt find word app when trying to write a new msg and therefore used its own email internal thing. The error was:
"The add-in et.dll could not be installed or loaded. The problem may be resolved by using detect and repair." I tried this but detect & repair doesnt seem to be installed.
I've located the et.dll in system32 folder.

Could the two be related? any ideas on what to try?

I have just installed Office 03.

If I am logged into Windows XP Pro SP2 as an adiministrator, Excel & Word work fine.
If I am logged into Windows' 'User' account, Excel & Word try to install something & give error messages.

Any thoughts on how to resolve this?

I originally posted this in the excel forum but perhaps this is a more suitable location:

I just installed Office 2008 for Mac, having used Office X (a much earlier version). I'm using a small powerbook 12' and found that Office programs open in windows which are not maximized and so I always had to use the mouse to drag and expand the window to fill the available screen area. I understand this is not unusual for Macs but the screen is smaller at 12" and I would like all available screen space.

In Office X, I was able to install a VB macro to set default window size and Zoom in Word and Excel. However for Office 2008 (Mac), I recently found a website offering 2 useful applescripts for Word, including
1. Measure the dimensions and zoom of an open Word document (script 1)
2. insert the 4 measurements into another script.
3. Add a keyboard shortcut to do this without clicking on the script icon.

Is there a similar option for Excel?
I can supply the original macro if necessary.


Office XP Professional Full install.
Specifically in Excel XP I have my Options set to have "Windows in Taskbar".
The trouble is with multiple Excel workbooks open and they are represented
by separate icons on the taskbar, when I close ONE of these windows ALL of
the Excel windows close.
This is NOT what I want. I only want to close the window (Workbook) I'm
currently clicking on. The others are to remain OPEN.
This is the behavior of Word when multiple windows are open on the taskbar.
Is there some setting I'm not seeing or is there an Add-in to install?

Please help.

Dave French
MOS XP Master Instructor (who is very confused at the moment!)


I managed to successfully design new THEME with custom colors and fonts to implement company visual identity with a help of OFFICE theme builder. It is a pleasure to see how companies visual indentity is implemented in all Office applications and every detail ( ie. Excel, Word, PowerPoint, Outlook) once you install new THMX.

I am stuck with one final detail. Colors were implemented to build visual identity in PowerPoint slides and charts first. Now word Heading2 and Heading3 colors are to pale.

I can not find documentation how to implement Woprd Heading colors in Theme Builder without ruining existing color scheme in PowerPoint or explanation how PowerPoint and Word colors are related.

Any hints?

I'm running Excel 2007 and Vista on a Dell desktop PC. For some time now I have only been able to open an Excel workbook if I first of all open Excel itelf and then use 'Open' icon to find the workbook document and then open it from there. If Excel isn't open and I try to open a workbook that, eg, I've found using Windows Explorer I get an error message reading:

"Windows cannot find 'C:\Users\Family-Administrator\Documents\My Documents\xxxx\xxxx\xxx.xls'. Make sure you typed the name correctly, and then try again."

Excel itself appears to have opened behind the error message but for some reason it won't open the workbook document.

I've checked the file path in the error message and it is the correct one, it's the same as the file path if I open the workbook from within Excel.

Excel didn't have this problem when I first installed MS Office 2007 a couple of years ago, the problem just started for no obvious reason one day. The problem doesn't occur if I'm opening Word or PowerPoint documents, eg if I click a Word file anywhere it automatically opens Word and then the document.

Any suggestions how I fix this? It's annoying me that I always have to open Excel first!

After downloading SP-3 for Microsoft Office 2002, when installing updates to
Xcel a message asking me to insert my MS office Small buisness disc because
iy can't find a sberet,msi file. My Dell PC came already loaded wiht the SBE
and I have no discs. Word, Powerpoint & Publisher updated fine. Why not Xcel.
What do I do now. Don't tell me to call Dell a/c they do not supply discs on
older versions.

recently I bought a new laptop with Windows 7 installed ( prob the worst thing I did ) and am having big problems trying to install Addins that I had on the old puter with XP.
I downloaded a fresh copy of the Addins and when I double clicked on them to install them, I get a message
" Excel found unreadable content in this file -- do you want to recover the contents of this workbook etc "
if you click " yes" you get some lines of code but not the Excel worksheet
and obviously the Addin won't install

I changed the Excel Trust Centre settings and now use a separate folder for all Excel sheets for simplicity --- downloaded a new .zip copy to that folder, unzipped it there
when I try to install the Addin, exactly the same problem
I sent a copy to a friend with Windows 7 on his machine and the Addins install as they should -- can't figure that one out ??

any advise appreciated

My PC has suddenly started displaying the above message whenever I attempt to
open Word or Excel files on my hard disc. My files are not corrupted as I get
the same error when using a diskette containing files which are months old. I
use Excel 2002 (10.6501.6626) SP3 installed from an Office XP ** & Windows XP
Home SP1. Is this a program or operating system error? I can find no help
anywhere! Problems with both Word & Excel files occurred simultaneously. Just
noticed similar problem with Powepoint, displaying "Powerpoint can't read
<filename>" message.
Any help would be much appreciated.


I had installed a trial version of Visio 2003. Since I removed it, I get an
error that says "error loading dll" when starting Excel. There are similar
errors (sometimes) when exiting excel. I do not see any other effect and
the event log does not show anything.

How do I resolve this problem?

If I do a "repair install," do I have to install all patches?