Over 1 million tech questions and answers.

Excel 2010 file will not open in excel 2007

Q: Excel 2010 file will not open in excel 2007

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: AMD A6-4400M APU with Radeon(tm) HD Graphics, AMD64 Family 21 Model 16 Stepping 1
Processor Count: 2
RAM: 7650 Mb
Graphics Card: AMD Radeon HD 7670M, -2048 Mb
Hard Drives: C: Total - 931724 MB, Free - 865841 MB; D: Total - 21840 MB, Free - 2343 MB;
Motherboard: Hewlett-Packard, 18A7
Antivirus: Norton Internet Security, Updated and Enabled

I am unable to open a password protected Excel 2010 file in Excel 2007.

When attempting to open this file nothing happens but on clicking the office button the New and Open options are available but all the other options are greyed out.

Using the open option has no effect on this file whatsoever.

I would be grateful for any suggestions.



Preferred Solution: Excel 2010 file will not open in excel 2007

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Excel 2010 file will not open in excel 2007

Does is need to be saved in a different format. Wasn't there a change in the default around that time??

Read other 1 answers


After a power outage a particularly important file gets the error "Excel cannot open the file.xlsx beacause the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. The file format has not changed. Is there a safe free program that can uncorrupt a file? I have tried Open and repair, changing the format, and using open office. Also tried using recova but the file was not lost.

A:Solved: Excel 2007 spreadsheet gets error "Excel cannot open the file .xlsx.." How ca


and 5 ways are shown here http://www.wikihow.com/Recover-a-Corrupt-Excel-File

Read other 2 answers

As part of updatting our computer equipment I was reassigned from a Dualcore Windows XP Sp2 with Office 2007 to a new Quadcore Windows XP Sp3 with Office 2010. Both with IE8.

The problem at hand is this particular Macro that is run monthly and creates 167 web querys, one at a time. This is why I made a macro. The webpage that I get my imformation from is http://www.systematics-int.co.uk/, which has a login page.

What I used to do in Excel was to first manually create a web query in such page in order to enter my login credentials, confirm that I entered the page, close the query wizard, and then proceed to run my macro. It worked, and still works, flawlessly in my previous PC but not so much in my new one, as all I get from the macro are a bunch of worksheets saying that I'm not logged in so I can't retrieve any information.

I hope I've been explicit enough as how it doesn't work. I really need this to work because my old PC is going to be formatted and my only option would be to do this manually.

If you need more info please ask, I don't think I've been clear enough as English is my second language.

A:Excel 2010 web query is not working as it did in Excel 2007

Could ik be that the symantec site has attached your login to a specic Ip address or machine name which now is changed because of your new system?
I don't really think it;s Office 2010.
Your system is new, another mac address, probably a new IP address, new computername.

All these seeminly irrelevant factors may be the reason it's now working, have you tried executing your macro step by step? Trubleshooting takes a lot of patience and time.

I hope this gives you some ideas to look at

Read other 2 answers

I am running Microsoft Office Professional Plus 2010 on Windows 7.

When I open Excel my personal.xlsb opens fine and my macros are available and I can create new macros. No problems.

BUT when I open any existing Excel file the pesronal.xlsb is not opened and therefore no macros and I cannot create new macros as I get the error "Personal Macro Workbook in the startup folder must stay open for recording." I have been trying things all night with no luck. Any suggestions would be greatly appreciated. I will list the things I have tried or checked with no success below:
In Options>Advanced Tab>General Section....the box for "Ignore other applications that use DDE" is NOT checked.
In Options>Trust Center>Trust Center Settings>Trusted Locations... I have C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART listed which is where my personal.xlsb is located
In Options>Trust Center>Trust Center Settings>Macro Settings ...Disable all macros with notification...selected and not selected neither way solves the issue.
In Options>Add-Ins>Manage: Disabled Items ...There are no disabled items.
I have deleted HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel in the registry editor
I have deleted C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB and then run excel to create a new personal file.
I have renamed C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB to PERSONAL.XLSA

Thank you in advance fo... Read more

A:PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010

Read other 6 answers

Problem in Excel 2010 [but revives a Closed TSG thread for Excel 2007]

The "Personal Macro Workbook" is a file called Personal.XLSB
The Personal.XLSB file is in the correct location /XLSTART/
The file properties option "Opens with Excel" is selected.
The file contains a (freshly re-made) macro.
(It also contained the same steps macro before it was deleted
and re-recorded during troubleshooting for this problem.)

When Excel is opened, the Personal.XLSB DOES NOT OPEN WITH it.

Because the Personal Macro Workbook does not open,
- existing macros do not function,
- nor can new macros be recorded

Same not-opening result, whether opened by clicking on
- Excel, in the Programs list or
- a desktop shortcut to a specific Excel file

However, the Personal.XLSB file can be opened and the macro made functional
by manually opening that file where it is stored in /XLSTART/

An unexplained workaround was identified in the closed thread.

*rename the Personal.XLSB to Personal.XLSA

I find this workaround effective.
The Personal.XLSA file opens with Excel and the macros are available.
But the file seems to be grayed out when viewed with Explorer in /XLSTART/

However, I do not like using workarounds, as they can cause trouble later.
I find that the "open with" setting was changed when the extension was changed
The setting is now "Opens with: Windows Shell Common"

I would appreciate an explanation how to make Personal.XLSB open as it should.
... Read more

A:Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

Read other 16 answers

We have some excel 2007 files that we cannot open. These are legit spreadsheets that were created here, not emailed in from the outside. When opening these files, we get a popup

Microsoft Office has identified a potential security concern.

file path: c:\......file.xlsx

Automatic update of links has been disabled. If you choose to enable automatic updates of links, your computer may no longer be secure. Do not enable this content unless you trust the source of this file.

Whether we select Enable to Disable, excel just opens up without any file displayed and no other messages. Any help would be appreciated.

A:Can't open Excel 2007 file

These files may be from a older version.

Check out http://office.microsoft.com/en-au/w...in-previous-versions-of-word-HA010044475.aspx

Read other 3 answers

Hi! i need you help!.. I am unable to open or save files in the shared drive using Excel 2007 but i can open/save excel 2007 files saved in my local drive

The error message I get when i try to open is "Could not open...." followed by the path and excel name.

This is the error message i get when i try to save in the shared drive:

Microsoft office excel cannot acces the file". There are several possible reasons:

the file name or path does not exist
the file is being used by another program
the workbook you are trying to save has the same name as a currently open workbook

Please help

A:Unable to Open and Save Excel files in the shared drive using Excel 2007

Read other 15 answers

Running Windows Vista Premium Home Edition.

I have an Excel 2003 spreadsheet.that I originally created on Excel Office Professional Edition 2003. Also, have Excel 2007 Home and Student Edition installed. I uninstalled the Excel 2003 software, but now when I clik on this created Excel 2003 spreadsheet with Excel 2003 it will not open. It says there is an invalid path. I reinstalled Excel 2003 and it opens. I tried to save this as an .xlsx extension and then uninstalled Excel 2003. It wouldn't open. So something is occurring here. On other Excel 2003 created spreadsheets, they open without issue.

Then I have a program with an .exe extension. It needs to open using Excel 2007. With both Excel 2003 and Excel 2007, it will not open. It freezes and then I get an error message saying it cannot open with another Excel other than 2007. If I right clik on the .exe program, there is no "Open with". I even tried opening a blank Excel 2007 spreadsheet and then cliking on "Open". but it is a bunch of gibberish. My IT person says you can't open the program that way, You have to launch it as an .exe program using Excel 2007.

Any ideas on what is going on? By the way, I have both Excel versions on my laptop running Windows XP and I do not have these issues at all.

A:Solved: Some Excel 2003 & Excel 2007 applications won't open on Windows Vista

Hi there,

If I said I was confused that'd be an understatement I think. You cannot open executable files (*.exe) with Excel. Recognized file types are things like .xls, .xla, (for 2007) .xlsx, .xlsb, .xlsm, etc. I don't know what your exe file is and I'm not sure I wanna know, but it certainly doesn't open in Excel. What is it exactly? If you don't know I wouldn't open it. Or if someone told you to open it with Excel then it's probably a virus. Unless I'm missing something here.

With the file in question which won't open, assuming it's not this strange and unknown exe file you're talking about, sounds like the file may have been corrupted. Does it open on any other machine? And if you uninstall Excel 2003, did you re-install 2007? It seems strange. I would try cleaning out your application and reinstalling 2007 fresh. You can't install 2003, then 2007, then take off 2003 and put it back on, you're gonna get things screwed up. I bet your registry doesn't know which way to turn here. Some good info on it can be found here...


Also, I would highly recommend you completely uninstall all versions, and I'm talking a deep cleaning, then reinstall. For that deep cleaning, take a look at this article (which I'd highly recommend you do) and then reinstall...

http://officearticles.com/misc/remove_microsoft_office_from_your_pc... Read more

Read other 2 answers

I have a 32 gig flash drive on which is an MS Excel 2007 file with all my passwords, serial numbers etc.

Last week I purchased a new HDD and successfully installed Vista Home and MS Office 2007 but when I click on the Password File on the flash drive, I get a message that "Excel cannot open the file .............. .xlsx due the file format or extension being invalid. Verify that the file has not been corrupted and that file extension matches that of the file format.

I have tried opening it in MS Word and other similar programs but no joy.

I downloaded the MS Compatability Pack but nothing................

Any ideas on how I can get this important file to open properly using Excel?

Virtually nothing has chaged to my way of thinking except the reinstallation of Excel again!!

A:Cannot open MS Office 2007 Excel file

It doesn't help, I know, but if you manage a successful recovery, I'd suggest saving what is a crucial file in text form. "Ah, you fool!" I hear you say. "Text files can be read by anyone. Why would I keep my passwords etc. in a text file?!?" To that, my response would be ADS. Look it up.

Read other 3 answers

Tech Support Guy System Info Utility version
OS Version: Microsoft® Windows Vista™ Business, Service Pack 2, 32 bit
Processor: Intel(R) Core(TM)2 Duo CPU T7800 @ 2.60GHz, x64 Family 6 Model 15 Stepping 11
Processor Count: 2
RAM: 3581 Mb
Graphics Card: NVIDIA Quadro FX 1600M, 256 Mb
Hard Drives: C: Total - 112352 MB, Free - 46118 MB; D: Total - 2047 MB, Free - 1384 MB;
Motherboard: Dell Inc., 0JM680
Antivirus: PC Cleaner Pro, Updated: Yes, On-Demand Scanner: Disabled

My antivirus is not PC Cleaner Pro. I decided not to purchase. I have Norton 360.

I have had icons on the desktop pointing to Excel 2007 inventory files. Now I get a message "Windows cannot find ....... .xls. Make sure you type the name correctly.."
I can go into Excel 2007 and open it so I know the file is there but I can't get the shortcut to work.

A:Can't open file using Excel 2007 shortcut

Read other 6 answers

I have an xls excel file saved on the server at work. It opens with computers running excel 2003 however when a computer running excel 2007 tries to open it, it just opens excel and displays a completely white screen. I am able to open all other xls files as far as i know. I've tried opening excel and then opening but that doesn't work either. This is a fairly large file that is updated daily by about 10-20 users. some running 03 some running 07. If i open the file on a machine running excel 03 and save it in a new document I am able to open the new document with excel 2007. However, there are hundreds of comments associated to specific cells that do not get copied into the new file.

Anyway, any help would be greatly appreciated!

A:Excel 2007 wont open a xls file

i will move to business applications forum - where you should get appropriate replies

Read other 1 answers

Dear all,
I cannot open embedded pdf file in Excel 2007 and Excel 2010.
When I try to open it, I get a message: Cannot start the source application for this object.
I checked the registery, the path is correct.

I cleared [ ]Enable protected mode at startup in Adobe Reader X.

Unfortunately, it still doesn't work.

How can I fix it? Please kindly help, thanks in advance.

btw, I can't access adobe.com, so if the solution is on this site, please copy it here.

A:cannot open embedded pdf file in Excel 2007

There's still no solution so far.
I sought many resources from Internet, and it was a compatibility problem between these 2 corporations.

Read other 1 answers

i have office 2007 in my xp os & i am unable to open excel file but able to other word, powerpoint,paint,outlook applicatios.

A:office 2007 excel file is not open

What happens when you try to open them?

Read other 1 answers

It would be really great and really appreciated if you could help me with a problem. I am unable to open an excel 2007 file in which I have stored examination results for a class of over 140 students.

When I click on the file I first get this message:

"Excel found unreadable content in "2.1 Marks.xlsx". Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

I can click on yes or no. When I click on yes, i get the following message:

"Excel can not open the file "2.1 Marks.xlsx" because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file"

Then I have to click on "OK".

How can I open this file to see my data???? If even I could open it once and print it off that would be enough.

Thank you for any help that you can offer.

A:Unable to open Excel 2007 file

Read other 9 answers

I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?

I hope somebody can help

A:Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

Read other 6 answers

I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The interesting thing is that if I try to open the same file that I have saved within the last year (before I got 2007) then I can do it? That is, I have a cache folder of files that I go get to do calculations then save in a new job folder. The ones in the new job folder will open (also 2003), but the ones in the original cache will not? I would truly appreciate any suggestions. Thank you.

A:Can't open 2003 Excel Files in Excel 2007?

Have you attempted to set them up in 'Compatibility Mode." Not sure if this will help, just hoping it will. I have been testing the new Microsoft Office 2010 Beta 64 bit, and have yet to have this problem, and like you I have a great deal of files in 2003 (never used 2007)'

I think you can still download MS Office 2010 beta from Microsoft's download site. Good Luck.

BTW, Welcome To The Seven Forums.

Read other 9 answers

Hi All,

I am trying to open Excel 2007 (.xlsx) format file from desktop, but i cannot able to open the particular file. If i try with open with and select the Excel file from program files also cannot able to open it.

I did not get any error message regarding the same.

And also if right click on desktop and select new also there is option for creating Microsoft excel file. I don't know what i can do it for solve this issue.

Please help me on this.



A:Solved: Cannot able to open Excel 2007 file from Desktop

Read other 12 answers

I had several spreadsheets open, including a fairly large one with 10 tabs and large tables of data. The file itself is 3.5MB.

I was working on the file, and I might have accidentally hit Ctrl-Z -- not sure. Suddenly the spreadsheet window vanished. No sign of my spreadsheet anywhere. The other spreadsheets were still open.

I tried opening it again but nothing happened. I exited Excel and it asked me if I wanted to save the changes to the spreadsheet, so Excel apparently still had it open. I saved.

Now if I try to open the spreadsheet, excel works for a minute, then stops. It says "Opening spreadsheet.xlsx" with the progress bar, then that clears as if it had finished opening the file. But the file isn't open.

Any guesses what happened? Is there any way to recover this file??

A:Solved: Excel 2007 suddenly can't open file

Now luckily for you I can replicate this in Excel 2010

Is it possible the shortcut you managed to hit was the 'Hide' button, which hides entire workbooks?

To see if you can get it back go to the View tab and see if you can click 'Unhide'. If you can click this then you should see your workbook name and clicking Ok should unhide it.

Hope this helps!

EDIT: Apparently the shortcut to hide workbooks is Alt + W + H so not so sure now if you manged to hit all that at once!

Read other 2 answers

Hi guys,

Since a day or two I?m having the following issue when I close an excel file (extension xlam).

I write my own addin files and have been using them for many, many years.

I?ve read that this seems to be a bug with Excel 2010 but the strange thing is why now and not before?

The addin is not installed, I run it when I need it, it contains the necessary xlm code with custom ribbons and all the necessary buttons, you name it, it just works as it should.

I have one button that either close the addin or quits Excel altogether

The VBA project?s properties are set to non-visible and password protected.

Now I get the dialog prompt to enter the VBE password. If I enter the password or press cancel, all I get is that Excel has encountered a problem and will shutdown.

OS: Windows 10 64-bit, Office 2010 and everything has been running fine with Windows 01 and before that with Windows 7

VBA Editor window is not maximized (as I read on several posts), and when I remove the password and save it and then reopen the vbe editor does not show up anymore when closing.

If I run the same macro directly, not using the menu button, the same thing happens. It seems like it?s trying to access the VBA properties, but I have not added any code to do that.

Very strange and especially I do not like thing I do not understand, no changes made and I do not address the VBE components in any way.

Any ideas?
P.S. I cannot upload the file but the thing is that it just started, all at on... Read more

Read other answers

Most of my Excel files open fine with a doubleclick from Windows Explorer. I have two XLSX files however, that "try" to open when I single click. They open to a blank, grey screen - essentially they open Excel, but the file does not open. (I do see a quick flash of tabs at the bottom indicating the file is starting to open or opens and then terminates immediately).

The problem is clearly not a "tiled window" or "window offscreen" problem - there is no file open. All the Excel functions are greyed out. If I go to File-->Options, i just get a blank grey screen. If I go to file --> open, I can then open any file.

It seems that these two files have some kind of trigger property that starts Excel with one-click, but I can't find how to change that property. None of my other XLSX files act this way.

UPDATE: Further experimentation reveals that this problem is somehow linked to password protection. I copied all the tabs to a new sheet and saved as XLSX. This sheet works normally, i.e. I can click on it once to highlight it and it does not open Excel. I double click and it opens. But once I password protect it, the behaviour changes to that described above.

A:Excel 2010 - Excel Opens Blank on One Click of File

Do you have the "preview pane" on? if so, turn it off and you should be able to view the password protected documents properly.

Read other 1 answers

I'm using XP pro and Excel-2007. Recently switched to Office 2007 (from Office 2003) and have the following problem when opening any Excel file:

When I try to open an Excel file, MS-Excel starts right away but it takes while (MUCH LONGER as compared with Excel-2003) before the file opens/gets displayed. BTW, I do not have any add-ins enabled.

Can anyone please help me solve this problem?

A:Solved: MS-Excel 2007 takes too long to open a file

Read other 7 answers

Hi all

I'm hoping an Excel 2007 guru can help me out.

I work for a medium size company and am stumped with a current problem I have open. I'm starting to think that the "problem" is by design.


An Excel 2003 (.xls) file is saved on our network,
All of the staff now use Office 2007, or in this case, Excel 2007.


Here's where it gets messy.

The staff tell me that under Office 2003 one person with write access to the folder share could open the Excel document and make some changes whilst leaving it open. Another staff member with read access to the folder share would then open the Excel document and be able to click "Refresh data" to see the updated data as the the person with write access was saving. Essentially, one person had it open to make changes, another person had it open (in read only I think) and would click "refresh data" from time to time to see the updates. Does this make sense?

Now they tell me they can no longer do it. If they try clicking the data tab and "Refresh All", nothing happens.

My question is, can an xls file be opened by one person in write mode whilst others open it in read only mode with a view to refreshing the data as the "writer" makes and saves changes?

Any comments or suggestions welcome.


A:Excel 2007: Refreshing data when two users have the same file open


Read other 3 answers

Hi there.

I'm trying to open an Excel 2007 document with Excel 2003. I thought that I had downloaded what I needed to be able to do that, but I guess not. Is there a way to do this? I suppose I could upgrade to newer version if I need to. If so, should I go ahead and get the newest version and get it over with?

Thanks for your help and time. Have a good day.

A:Open an Excel 2007 doc with Excel 2003?

Have you tried the office 2003 compatibility pack https://www.microsoft.com/en-us/download/details.aspx?id=3

Read other 5 answers

Excel '07 won't open an "excel 4.0" macro (i.e. *.xlm file). I am one of a few users at work using excel 2007, I believe this file was made with excel 2000 or similar. When I had excel 2000 it opened fine, it's a common file on the network that everyone should be able to access, and everyone with excel 2000 can easily. So I know it's not the file. When I try and open it with excel 2007 I get that stupid error about the file being different to the extension.

I've tried registry edits and workarounds after scowering the net but nothing seems to fix it. All it does is display the error, then opens excel in the background without even a new worksheet. Excel isn't hanging, it just does nothing. Any ideas?

A:excel 2007 won't open excel 4.0 macro

XLM was long ago replaced by VBA (with Excel 5 in 1993) and MS no longer really supports it (although I think they claim that they do, kinda, sorta.) So the only thing you can do, I think, is to make a copy of the xlm file and convert the xlm code in the copied file to VBA. Fortunately, I found a link that tells you how to do that:
(Look at the link at the bottom, too. But you will need to download that to an older PC, possibly.)
Now, assuming all goes well, this will give you two versions of the same file, but if everyone else has Excel 2000 (or later) then they will all be able to use the new VBA-based file, so you won't end up with two files that would lead to confusion.
Still, it looks to be a lot of work, so good luck!

On a final note, if you need this file done in VBA and you can't figure out how to redo it, make a post describing your needs - there are some amazing VBA coders on here.

Read other 1 answers

I have a document created in Excel 2000 with many sortable rows. It responds quickly in Excel 2000 but when I hope it in Excel 2007, it is very, very slow.

Is there a way to solve this for use in 2007? Take off filters then re-add?

The computers are brand new Core 2 Duos. Thanks!

Read other answers

Hello, I am having the following problem. If I try opening a pre 2007 excel file, in excel 2007. I get error messages saying it cannot find certain files. The weird thing is, say my file was located at:
C:\Documents and Settings\Me\My Documents\test.xls

I would get the following errors:

'C:\documents.xls' could not be found.
'and.xls' could not be found.
'Settings\Me\My.xls' could not be found.
'Documents\test.xls' could not be found.
Pretty much, for each space in the file location, I would get an error message. Eventually after accepting all of the error messages, I would be allowed to view my document.

A:Error opening old excel file in excel 2007

Read other 14 answers

I have a friend who is suddenly experiencing an issue where they are no longer able to Open an Excel file through their Windows Explorer (e.g. when trying to open a Excel file from within their My Documents folder). After double clicking on the file, Excel opens and acts as if it is opening the file but then proceeds to show just a blank worksheet. The file does not appear to be corrupt since they can then go to File/Open from within Excel, locate the folder and then Open it without a problem.

Any suggestions? Any ideas would be greatly appreciated as to the cause and resolution for this.

Thank you greatly,


A:Excel 2000 - Unable to open Excel file thru Windows Explorer

Check this out: http://www.pcreview.co.uk/forums/thread-1781119.php

Read other 1 answers

I am using an ASP.NET 2.0 web application using the Interop assembly pointing to the Microsoft.Excel 12.0 COM to open and write to a spreadsheet.

I have set the permissions for the DCOM to allow NETWORK SERVICE to open the Excel application, but when I try to open the actual file I get Exception from HRESULT: 0x800A03EC.

I have changed the website directory permissions to allow NETWORK SERVICE full access to the folder and I still cannot open the file.


Read other answers

Created a worksheet with formulas, in Excel 97, and saved it on floppy and hard drive. Can open worksheet from floppy and hard drive in Excel 97 but not Excel 2003. Formula cells become #NAME?

Sample of formula:
='C:\blp\api\dde\Blp.xla'!BLP(C190&" equity","ask",,,RTD("BLOOMBERG.RTD","","IZU+UV Equity","ASK"))

How can I resolve? Thanks.

A:Solved: Can't Open Excel 97 File in Excel 2003

Read other 7 answers


On a PC in our office, there are a number of Excel 97 files which have a problem.
I think they were originally created on a Windows NT, or possibly even Win3.1 machine, resided on a floppy and were eventually given to someone in our office to enter data.
The files are stored in the My Documents folder on a W95 machine.

These files can only be opened by starting Excel and using the Open command and locating them.
If I try to open them directly from the My Documents folder, I get a series of error mesgs, splitting the name of the file and path:

Cannot find file C:\My.xls
Cannot find file Documents.xls
Cannot find file \Cold.xls
Cannot find file Repairs.xls

and the file refuses to open.

If I save the file to disk and try running it from another PC, it says "file may be read only", which it is not.

The file contains no VB code and no add-ins are loaded.

I also tried copying all the data from the file into a new file. This worked until I moved the old file out of My Documents and renamed the new file "Cold Repairs", upon doing so, the same errors occurred again.

Any ideas?


A:Excel 97 file only opens from open Excel window. Help!

Read other 8 answers

Hey all,

I have come to you in a fit of desperation. My USB drive was stolen recently and my master Excel data file was lost, which contained all my compiled data from my most recent lab experiment.

Anyway, I have charts of all the important stuff in a word document. The data is there, I can hover on each data point and see the values, and the axes and chart are all accessible for editing.

My question is, how the heck do I extract that data back out of the chart into a table or Excel spreadsheet? There MUST be a way that is better than copying down each data point one at a time

Your help is greatly appreciated.

A:Excel chart in Word 2010: extract chart values? Lost Excel data file!!!! Help.

Hi welcome to the fourm.
I don't know it reverse engineering is possible.
Something like convert chart to table?

One thing you could try is copy the chart back to a new Excel file and see if more is possible there than in Word?

Like I said never needed this. Have you googled for something like Excel data reverse enginieering?
Maybe something come up.

Read other 1 answers

My computer crashed a few days ago. I've been able to recover most of the data except for a very important excel document. I'm able to open it but when opened it only displays jibberish. IE - weird symbols like squares and greek symbols and numbers instead of words. Any idea on why this is happening and how to fix it. The only other thing is that I was previously using an older Microsoft Excel. When I recovered my computer I installed a newer version of Excel...but I didn't think that would any difference because of backwards compatibility.
Thanks a lot to anyone that can help.

A:Excel: Can't open recovered Excel File.

Read other 8 answers

how to email a excel sheet or excel workbook direct from excel ?tell me the steps.. all of excel 2007,2010,2013.

A:help about excel 2007,2010,2013 all.

Send as an Attachment>

will send the work book , which will use your default email client on the PC

Read other 2 answers

I have some very large spreadsheets ( 7000K to 11150K in size ).
These were developed using Excel 2007 on a Windows XP 32-bit 2GByte RAM computer.
Encountered out of resoucres error message when trying to copy and paste formulae and formats.

Concluded computer did not have enough memory so upgraded to computer with
Intel Quad Processor
8 Gbytes RAM
Windows 7 64-bit
Excel 2010 64-bit

Problem still persists.
Spreadsheets have a great deal of conditional formating rules
Also a very large number of defined NAMES local to individual worksheets
Each spreadsheet ( workbook ) has approx 125 - 185 separate worksheets
Most have identical structure - each referiing to a particular date so data varies.
Huge number of formulae in each worksheet.

Can anyone give me some clues as to what is going on inside Excel 2007 / 2010?

A:Excel 2007 and 2010 out of resource issue

I'm not sure, I have large spreadsheets myself and no issues and my computer has less memory but maybe if you disable automatic calculation before running the macro's and turn it on afterwards it will help?

See link below for some code indication.
I turn off events when I change a sheet until the process is complete and turn it on afterwards

Application.EnableEvents = False
< code>
Application.EnableEvents = True

I don't know if it will make a difference for you, but it won't hurt trying it.
Don't forget to make a backup before you do it.

Read other 1 answers

    I have done this twice now, and still haven't figured out the resolution.  I have office 2003 installed on windows 7 pro machines. The users then try to open excel 2010 spreadsheets, and they wont open because they are not compatible. But there is an office 2007 patch. I know, I use it on all the desktops that have office 2003, but I forgot to in these two cases. 
  So once I have the problem corrected, I have the fix, and I wont do it again.
 The problem. The office 2003 .xls file wouldn't open. I decided the file association was missing so on the .xls excel spreadsheet I highlighted it then right click>Properites>change.
Then i go to Browse C>local disk>Program files (X86)>microsoft office>office 14>excel. The association is wrong. I have tried to uninstall office and re install, but that did not help at all. I realized after i did this that the office 2007 compatibility pack wasnt installed so i installed the patch, but that didn't help either.
 The problem is that the xls is trying to associate with the xlxs,... i think.
 I am basically trying to dis-associate the .xls with any program and start over. I thought that it might be a registry setting? I have no idea anymore. Any ideas? I can't be the only one who has ever done this?
Thank you in advance for any help you might be able to provide

A:Excel 2010~2003 to 2007 debacle

First of all, welcome to BC !
Try coming at your problem from a different direction. Go into Windows Explorer and pick on one of your Excel 2003 files - any one will do. In Windows Explorer RIGHT click on the name of this poor innocent file. In the menu that will open, click on 'Open with...', this will bring up the 'Open with' dialogue box.
In the centre of the box you will see an Excel icon. Do NOT click on this, instead click on 'Browse' at the bottom right hand side, and browse to excel.exe (Office 2003). The path is :- C:\Program files (or Program files(x86) if 64 bit systems)\MS Office\Office 11.
Office 2003 is listed as OFFICE 11. Here you will find an excel.exe file with the familiar icon beside it. Click on this to select it, then put a tick in the box on the other side of the 'Open with' dialogue box, the one that says 'Always use this to open files of this type'. You have just changed the attribute of all the Excel files in your system, and they should now all open in Excel 2003.
You are correct, you need the 2007 compatibility pack to open 2007 and later files in 2003, and there will be a pause of a few seconds while the software translates from .xlsx to .xls, but it always works for me.
Chris Cosgrove

Read other 6 answers

This is so very strange and I am stumped. The user had Office 2002. I uninstalled it, then installed Office 2010. When she clicks on the Excel icon (from the desktop, or from the all programs list, and even from the MS Office folder in Program files) a window pops up and it displays "the name of a document" and "file format is not valid". It is trying to open a Word document! She said this was occurring with the old Office version also. Once that window is closed Excel work fine. It's as if the Excel executable somehow became a shortcut for this Word document. She said that the document was deleted quite awhile ago.

Any help would be appreciated.

A:Excel 2010 tries to open .doc

Read other 7 answers


Got a problem with Word and Excel 2007.

Both programs open ok (under 2 seconds), so no problems there.

The problem is opening the program by means of opening a document. It takes about 1 minute

Exactly the same thing with both Word and Excel.

Has anyone got a solution? Surely there must be a quick little registry tweak to sort this out?

Other info:
Outlook 2007 works ok, no delays
Windows XP works ok
No speed issues with computer
Did not previously have Office 2003
Word/Excel documents are local, computer is not on a network
Computer is free from spyware and viruses

A:Word and Excel 2007 - Programs open ok - documents take ages to open

Read other 8 answers

Couple of issues here.... help!

1) When I am in Gmail (email) and want to open a word doc or excel and try to open it by a click (internet explorer) it opens of the window that comes with the computer to "buy" or ... so I have to save on the desk top, open word or excel then open the document through the software.

2) When I am in Gmail (email) and want to open a word or excel document in (Chrome) it opens a little window which ask if I want to open, save or open/save and where to save it. If I press open another window opens and ask if I want to open it now.
How can I just click on the word or excel document from gmail or anywhere and it just open up instead of opening up the program to open within?

Thank you ahead of time!

Read other answers

I am using microsoft office 2010 and windows 7.

I have set up excel to open files from a specific folder. When I click open it only shows files such as *.xls etc.

How can I setup to open all files (*.*) ?

Thank you very much

A:Solved: Excel 2010 - How to set open to open ALL files

Read other 12 answers

I have an excel spread sheet that pulls data from multiple seperate sheet to then consolidate them into a single table that then uses a pivot table to pull together a 'class' list of everyone starting a set classs on the same day and venue with their contact details on including a phone number. For 1 person on the list the pivot table has added an additional 2 to the end of the phone number.

I have checked the original spreadsheet, the consolidated sheet and neither of thiose has the extra digit in it only shows on the pivot table.

The pivot table is set up with tabular layout so you get 1 line per person who meets the filters set to class start date and venue and i have checked that the column on the pivot table is formated the same all the way down.

Does anyone have an idea how the extra digit arrived and how i get rid of it? I have over trypwed the original data on the colsolidated list with some thing differnt and refreshed and then put the content back to the refernce cell and the extra 2 re appears - all very confusing

A:Solved: Excel 2007/2010 Pivot Table data error

Very hard to trouble shoot this on written notes. To find this... I would try moving/adding the person to another class. I would also try pivoting on class members and see how this entry appears. If still an issue I would make this thing with only the offending records and associated records. Excel usually doesn't make this stuff up.

In reality I would send this off and call it done!

Read other 3 answers

The ?problem? I?m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb.
I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit.The W700 has Office 2007 and theW541 has Office 2013.Both versions ofExcel are 32 bit as far as I can tell.
Until recently I was primarily using the W700ds but have nowswitched to the W541.

after I saw a larger file losing KB when saved, I did a test with a file that had not been altered or openedfor over two years. I copied it twiceand added a -1 and a -2 to change the names.The file was a small 832 Kb file.When I opened and saved on the W541 running Windows 7 with Excel 2013,the file saves with 771 Kb.When Iopened the file using the W700 running Windows 7 with Excel 2007, the computeron which it had originally been created, the file saved as 830 Kb.Both saved smaller but the newer computerrunning Excel 2013 was much smaller.Iam seeing these same types of ratios of reduction in size for much larger Excelfiles as well.

I have not documented any actual problems or loss of data withany of the files to date and I have used an Ultra-Compare text file comparison which found no differences.
Is there any reason to be concerned about this? And, if so, what to do?

As with many people, some of my files are the result of manyyears of work and I don't want to do anything to compromise any of the data butI don?t know whether or not what I?m seeing is normal due to both Excel 2007and Exce... Read more

Read other answers

I am having a problem opening a .tsv file with office 2010 running windows 7 on multiple machines.

Here is the situation:
I am exporting a document from Oracle. The file is in the .tsv format. It prompts me to open or save. Of course if I try either it tells me I need to set a default program to open the file. I search for the Excel program from my Office/Office14 file. Click Ok and then when I double click on the file to open it nothing happens.
I have tried manually setting the default association and it will never open the file.
This works flawlessly on a windows xp machine running Office 2007 or before. 2010 Excel is the only problem we have had.
I have only been able to trick it into using Excel so far. When it asks me to save the document I chose a location and type .xls after the file name. When I open it there is an error message and I have to resave it, but then it works.

If it was me I wouldnt worry about this, but I have 100 users that may start having this issue and they will not want to deal with it.

Any help would be appreciated.

Thank you

A:Excel 2010 will not open .tsv files

Read other 15 answers

Similar to your conversation string back in 2010, I have found the same problem: when exporting a .tsv file from Oracle (having already associated it with Excel through the Default Programs section of Windows 7), my computer thinks about it, then does nothing. I was able to do this seamlessly with Excel 2007. Any updates since 2010 on this?

A:Excel 2010 Does not open .tsv files

Hi, welcome to the forum.
Nothing's changed, 2007 or 2010, all the same.
Did you reset your association with Excel 2010 after you installed it?

Read other 1 answers

I was reading this past thread and am having the same problem with a few machines in the office. They are all running Office 2010 on Windows 7 and I can't get the file associations correct. The newer file extenions are fine but the xls and xlsx files will not automatically open when double clicked. They WILL open if you open Excel and then go to the file, open commands. The new 2010 files will open automatically when double clicked. Files are all saved on the desktop or same folder with different results. Does anyone know of a fix to this? I have done all of the normal fixes, repaired the installation, tried manually open with and checked the always open with box, went to options, advanced, and the "Ignore other applications that use DDE" was not checked. The ONLY thing I can think of is that some of these users are using Microsoft Project 2003. But I did do a full uninstall on Office 2003, fully uninstalled Office 2010 and re-installed Office 2010 and am still not able to have the users double click to open files. Any other ideas? (Again, only happening on a few machines, other machines running Office 2010 on Windows 7 are fine)

Read other answers

Hi Guys,

this issue only happens to 1/2 dozen of my PC out of 150, i don't what cause it and how to solve it. had tried /regserver and adding ExtensionHardening registry to each of the PC registry to no avail. tried the open with option, redirect it to excel.exe in office14, checked the always use this program check box, yet no avail. tried repairing...no avail too.

these 1/2 dozen PC, can't open any excel extension just by 2x clicking the file. they're all using office2010. OS: XP SP3.

any lead someone?

A:Excel 2010 can't automatically open xls and xlsx

Read other 7 answers

I am having problems trying to open Excel files by double clicking them for some strange reason.

If I create an Excel file then save it for some bizzare reason it won't then open again by double clicking it. I have tried to go into the choose default programs but I can't find Excel 2010 anywhere, so what I done was to create an Excel short cut on the desktop and then tried to use that as the default program but I get the following message:

C:\Users\********\Documents\*******\********\****.xlsx is not a vaild Win32 application.

(I have used the *'s instead of the proper path)

A:Can't open Excel 2010 files for some reason?

Quote: Originally Posted by BomberAF

I am having problems trying to open Excel files by double clicking them for some strange reason.

If I create an Excel file then save it for some bizzare reason it won't then open again by double clicking it. I have tried to go into the choose default programs but I can't find Excel 2010 anywhere, so what I done was to create an Excel short cut on the desktop and then tried to use that as the default program but I get the following message:

C:\Users\********\Documents\*******\********\****.xlsx is not a vaild Win32 application.

(I have used the *'s instead of the proper path)

Have you tried right clicking on an xlsx file, choose Open With, and browse to the excel.exe? I don't have 2010, but mine is in

C:\program files (x86)\Microsoft Office\OFFICE11\EXCEL.exe

Choose the exe and click always use the selected program...

A Guy

Read other 2 answers