Over 1 million tech questions and answers.

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

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

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

Preferred Solution: Unable to Open and Save Excel files in the shared drive using 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: Unable to Open and Save Excel files in the shared drive using Excel 2007

Read other 15 answers

In the last couple of weeks my machines running Office 2003 (Excel 2003 in particular) will not open "some" spreadsheets that are stored on a shared drive on our LAN. I can e-mail the sheet to a user and they can open it. They can copy it to their local machine and open it. They can double click the item on the shared drive, cancel the operation, open Excel, then open the "recovered" version of the document. They cannot simply navigate to the shared location and click on the file to open it. Well...sometimes it will open after 30 minutes or so. Other times after a long while the Excel window just closes and the list of files on the shared drive remain on the screen. There is never an error code either.

The only commonality is that Office 2003 is installed on these machines. Operating systems are XP Pro 32 Bit and 64 Bit with SP3, and Vista Business 32 Bit SP2. All machines have atleast 2 Gig of RAM and at least Dual Core Processors running at 2.6 GHz or above. The files being opened are all about 8meg each. The file conversion utility is on all of the machines (we do run Office 2007 as well and there are no problems with the '07 machines).

I installed a trial copy of Excel 2010 on the one Vista machine and there is no problem opening the files. That points me back to thinking that it has to be something with Excel 2003. I looked at the setting "Ignore Other Applications" in Excel 2003 and the box is already unchecked on all of the machines... Read more

A:Excel 2003 won't open some files on shared drive

Read other 16 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

At my business we use excel spreadsheets to hold data for many things. The excel spread sheets are located on the company's S-Drive and are shared. At any given time there can be up to 6 or 7 people in the files, updating data, etc. The problem we are having is that data is consistently lost, overridden by someone else saving, etc. Does anyone know why this is occurring on a regular basis if the files is shared? If so how to fix or minimize the issue?

Thank you in advance for any advise or help.

Read other answers

I have a similar problem as the previous posting but my problem is with Excel not Word. When trying to open any Excel file I receive the message: "There was a problem sending the command to the program." The only way I can access an Excel file is to open "All Programs," choose "Microsoft Office" folder, choose "Microsoft Office Excel 2007" icon, choose "Open" folder, and double click on desired file.

My computer is a three month old custom unit built with Windows 7 Professional. I am using Microsoft Office Home and Student 2007. There have been no problems until this week.

Thanks for any help,


Read other answers

Hi all,

I am experiencing some problems when trying to save an updated excel 2007 worksheet.
This worksheet as well as all other is saved in compatibility mode.

This occurs only with this particular sheet all other are working fine.

It started yesterday after updating the worksheet with new info.
I got the message "Microsoft Excel has encountered a problem and needs to be closed".
"Send error report"etc... I lost 2 hours of work.

I have downloaded the same very sheet from my company's Intranet (uploaded by myself a few days ago), and the error remained.

The weird thing is that this worksheet was working just fine until yesterday and all other excel docs are working just fine.
I have tried in safe mode doesn't work either.

Any help with this issue would be greatly appreciated.

Read other answers

I have been using Excel 2007 for over a year with no problems until yesterday. Now when I open a previously saved document, I can make changes to the cells, but cannot click on the Office button or any of the tabs across the ribbon. The only thing I can do is click on the "x" to close the document, which remains in its original form.

If, however, I open Excel first, and then open the same document, I can make all changes and save same.

Why can I no longer open and edit a document without opening Excel first, and how do I fix this? I'm new at these forums and hopeful that someone can help. Thank you!

A:Solved: Excel 2007 unable to save or click on ribbon


Try repairing the installation

Click the "Windows" button at the bottom left-hand side of your computer desktop.

Step 2
Click "Control Panel" and then "Uninstall a Program" under the heading "Programs."

Step 3
Scroll down until you see the version of Microsoft Office 2007 you own (such as Microsoft Office Home and Student 2007) and click once to highlight it.

Step 4
Start the repair process by clicking "Change" in the gray bar toward the top of the "Uninstall or change a program" window. Select "Repair" in the window that opens. The diagnostic tool will attempt to find and then repair any problems or errors it encounters.

Read other 3 answers

This has me beaten so far ...

I run a small home LAN, 2 XP PCs, simple wired XP LAN sharing files & printing.
There is an external drive on the first PC where we keep shared data. The significant folders are shared (for easier location), as is the drive itself.

I recently upgraded both PCs to office 2007, not sure if thats the problem though.

When the second PC tries to save a spreadsheet (new or changed) to a shared folder on the first PC's external drive, we get errors. Normally:-
path/filename 'is currently in use. Try again later.'

Of course its not in use and I can save to that folder OK from the first PC, we only get problems from the second PC. We run Zone Alarm so that's also a contender for the cause, but I have tried to isolate that as a problem without success.

Anyone got any solutions/ideas?


A:Excel 2007 Shared network drive 'busy'

Hi - me again

I tested it wasn't my firewalls, and I can copy files to the target drives with explorer - so I am pretty sure it has something to do with Office 2007. We did install office 2007 but we couldn't be sure it started happening around then, and from my PC I can save with office 2007 so it looked like it might be something else.

But everything else is pretty much ruled out now - so anyone got any idea why office 2007 would be so slow writing to an external disk folder that once it creates the empty file, it comes back saying it is busy? Yes, it leaves an empty file with the correct name & extention behind - wierd.

Help please!

Read other 1 answers

A user has tried to open an excel file from a shared drive to enter some data and he is now getting a message saying access denied, contact Admin. I have checked the permissions and he has full access, nothing has changed there.

I found that if the file is renamed, he can open it but when it is changed back to the original name, he gets the problem again. Basically, he cannot open the file under the name anymore.

Any help would be grateful because I have search everywhere and cant find a solution.

A:Can't open an Excel file from a shared drive

Maybe somewhat opened that file as read-only and it was cached? Tried restarting that particular PC?

edit: Hmm, can't open at all, right? Try restarting nevertheless

Check the PC that has the file for sessions and open files (computer management - Shared folders) and see if the user has an open connection, disconnect/close then try again

Read other 5 answers

All of these programmes run fine, but as soon as I try to use them to save my work or open an existing file, they stop responding! I'm using the 2007 version and Windows Vista.

Thanks for your help in advance!

A:Word/Power Point/Excel 2007 Programme hangs when I try to save or open!

You could try opening up word, select help and look for a detect and repair option. Give that a try and see if it solves your problem.

Read other 2 answers

Received a few MS Excel files from an outside vendor as e-mail attachment. I am able to save the attachement to My Doc or desktop and then open or open them directly from Outlook 2003 or 2007.

But when I tried to save the doc with or without making changes, the spreadsheet just sits there and saying Saving at the bottom. I waited several miniutes to be saved, but it just sits there. It does not taking any extra resources. On Application event viewer, it just displayes application hang error.

A:Unable to save or save an Excel files

Read other 16 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

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

Hi guys,

I have a question that has stumped me so far. Here is the scenario: I am dealing with a spreadsheet that has several tabs on it. In each tab, there are several word, powerpoint, and pdf documents that are embedded as objects. My task is to write a macro, that will for each document (keep in mind its an embedded object that needs to be opened), open it with the appropriate program, and save it using a pre-assigned name (the name of the column heading and the row it is in) to a predetermined folder path. This process needs to be duplicated about 200 times. I'm not sure if this is even possible, but I know enough about vba to believe that it is. I've been working on it since yesterday, and I can't seem to tie the pieces together. Can anyone help on this?


Read other answers

I'll try to make this as concise as I can:Problems/steps taken:- Running Windows XP SP 2/Office Pro 2003.- User noticed problem this morning; some corporate patches or updates may have been applied since yesterday (not sure).- Initially couldn't open Excel files by any method. Excel would hang and the task would have to be ended.- Used Add/Remove Programs on Office 2003 and chose Repair. Didn't notice a change. Then did Change on Office components and unchecked Excel to remove it. Later re-checked Excel to put it back on.- Noticed that I could now open Excel files by double-clicking on them or opening from recent Excel files list. File | Open or toolbar Open button still make Excel hang.- Also noticed that Save As command from the file menu (or the toolbar, if you add a toolbar Save As button) also makes Excel hang.Notes:- There are no files in XLSTART under the Office11 folder or the user's profile. There are no .xlb (customized toolbar) files on the system. There are also no Add-ins running and never were.- Running Filemon.exe (from Sysinternals.com) shows that several files are not found as Excel tries to Open or Save As, but I'm not sure I see any unfound files that should make any difference. It keeps looking for shell32.dll repeatedly after it's already been found in C:\Windows\system32, where the file does reside.--------SOLUTION (my boss found this, and it worked):This was caused by a recent Microsoft patch. There were apparently also about 40 insta... Read more

A:Excel 2003 Hangs When Trying To Open Or Save As Files - Solved

Hi hotshot309,

Thank you for posting your fix. It helps to see what the fix was.


Read other 2 answers

I have been using the Student version of MS Office 2007 for about a year and created many spread sheets using the above Excel.

After installing a new Hard Drive and reinstalling Office 2007, Excel will not open one single file!!!!

I keep getting the message that there is somne sort of "xlsx" error and as I know that is the "new language" from MS but why should files created on the same application fail to open simply because the application is reinstalled?

There just has to be a way to get my data back!

I downloaded the MS Compatability Pack but to no avail.


A:I give up with 2007 Excel - won't open any files for me!

Read other 6 answers

First time I have asked a question so hope someone can help. Can't identify when it first started to happen but recently all excel files seem to have converted to word files. If word is already running and I try to open an excel file it opens in word and office tries to reinstall.
All excel files are displaying as word files in my documents folders. if I open excel and then open the files they do open and I can then save them in the correct format and they stay in that format.

Hope this makes sense.

A:excel 2007 files open in word

Read other 8 answers

Hi, I have excel 2007 and can't open .xlsx files

A:Excel 2007 cant open xlsx files

Read other 6 answers

I have 2 comps that have this prob, both running xp sp2, I can open files (word and excel 2000 and microsoft works 4.5) from the network no prob. I can also save the files to the network drive.
The prob happens when i try to save as to the network drive, I recive the error

I can save the file to my hard drive.
I have no password on the file and the network drive is accesable.

I have unistalled and reinstalled the office (did not help).

All other programs have no problems with save as on the network.

A:unable to save as to network drive with word/excel 2000

Read other 14 answers

Hey guys,
First time posting here.

I have Microsoft Office 2003 & 2007 installed on my laptop and using windows 10. Laptop came with 2007 but 99% of my excel use is for work and they use 2003. So rather than downgrade (seemed silly) I installed 2003 also. Everytime I open an excel file either .xls or .xlsx it opens in 2007. Does anyone know if it is possible to set 2003 as the default program for all these files. I have done the basics like settings, default programs, but when I go to file type and find .xls & .xlsx the only programs I can set for these are Microsoft Office Excel. It does not let me choose between versions.

At the moment I have to open 2003 and then the file. Not a huge problem but if possible would like to make 2003 the default.

A:Default Excel 2003 to open all files over 2007

I don't have an answer for you.
Just to remind you that Excel 2003 can NOT open xlsx files, unless you install the compatibility pack.
Only 2007 and high versions are able to open xlsx by default.

Why don't you just use the 2007.
When you are ready to save the work > Office button > Save As > at Save as type, click the pointer and select Excel 97-2003 Workbook (.xls) > Save.
That way all your office excel 2003 computers will be able to open and edit it.

Read other 2 answers

I cannot access Excel files from shortcuts but can access the files from the application "file/open". This occurred recently and may be linked to a new update of Norton Internet Securty. The error message is unable to open 'filename'. Make sure you typed the name correctly and then try again. I had this problem about a year ago and eventually found a solution by searching a user forum database. The solution was to unselect a condition (permissions?) in either Excel or IE. I can locate that menu tree with the current application versions. the OS is Vista.

A:Solved: Excel 2007 Files don't open with shortcuts

Are you sure the shortcut is pointing to the correct file?

EDIT: Not understanding what this had to do with Web & Email I moved the thread.

Read other 3 answers

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.



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

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 transferred all my old Excel (2003 and before) files to my new notebook which has Vista HP and Excel 2007. I open an old Excel file and it looks OK but when printing or print previewing, every line appears double-spaced and the document runs over to a second page.
If I change the row height it prints the squeezed up text but still double-spaces. If I copy the whole content of the spreadsheet into a new blank spreadsheet it prints normally.
Is there any setting in Excel 2007 that I might have missed ?

A:Printing Excel 2003 files with Excel 2007 give double spacing

Read other 7 answers


I want to open multiple Excel 2007 files in separate windows because I have 2 separate monitors. This works with for example Word (just double click on two different word files) but not with Excel.
I read some work-around saying "open the first excel file by double clicking, then open an empty excel file via start button and then open the other file from within the new window."

But surely there is an easier way? For example setting folder options for Excel files?

I have Windows 7, 64-bit if that makes a difference.


A:How do I open multiple Excel 2007 files in separate windows?

Quote: Originally Posted by cyru11s


I want to open multiple Excel 2007 files in separate windows because I have 2 separate monitors. This works with for example Word (just double click on two different word files) but not with Excel.
I read some work-around saying "open the first excel file by double clicking, then open an empty excel file via start button and then open the other file from within the new window."

But surely there is an easier way? For example setting folder options for Excel files?

I have Windows 7, 64-bit if that makes a difference.


Hi cyru11s.
Is this link of any help to you?
How to manage multiple windows in Excel

Read other 9 answers

Getting the following error message every time I try to open one of my excel files...

Windows cannot find 'C:\users\steve\desktop\icbacashflow.xls'. Make sure you typed the name correctly, and then try again.

Is my computer infected with a virus? What gives? HELP!

A:Unable to open excel files

Hi stevekim99. . .

Welcome to the Teh Support Forum - Vista Support!

Is it just this one file - or are you having problems with ALL Excel files?

Are you running Excel 2007 - and are you sure that the file extension is .xls and not .xlsx?

Regards. . .



Read other 1 answers

Hey guys,

I'm Santhosh from Bangalore,India. Just registered. I need some help please. I'm using Excel 2003 although my MS-office is 2007. I had to delete 2007 excel cuz of some conflicts while accessing an excel file from a shared folder in my office. This new file consists of testers attaching a screenshot of error msgs onto Excel. That file used to open till yesterday. I haven't made any changes to my sys, but the attached file would just not open. I click on the .JPG attachment and all i get is the hour glass rotating forever and then a not responding Excel application, which i have to go to task manager and close it manually. Please help. Thanks in advance.

Read other answers

Hello I've been having trouble with my excel files.

Yesterday I edited one and today when I try to open it, an error message popped up and said that the file is a read-only file, hence cannot be opened. The similar thing has happened to several of my other files recently.

Am I making some ridiculously stupid mistake whilst saving the file or is there a virus on my computer?

Any help would be much appreciated as I don't know anything about computers :(


A:Unable to open Excel Files

Hi hohohoo, welcome to TSF.

If you're conscious of a virus infection, you need to check with the Security team by doing the following:

Otherwise, check if the files are indeed "Read-Only" - right clicking the file and checking it's attributes.

You could also try a Detect and Repair from within Office.
Open up Word, and go to Help > Detect and Repair.


1. On the Windows Start menu, point to Programs, point to Accessories, and then click Windows Explorer.
2. In the Exploring window, open the drive or folder that contains the file.
3. Click the file name.
4. On the File menu, click Properties.
5. Click the General tab.
6. Clear the Read-only check box.

Read other 1 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

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'm running MS Excel 2003 and suddenly this afternoon I can't get a single file to open either directly from Windows Explorer or a desktop shortcut. And when I try to open Excel via Start-Programs-Excel I briefly see it appear on the monitor but it immediately retreats to the desktop taskbar and I can do no more. When I try to open more Excel files they just hide in the taskbar and cannot be opened.

I have rebooted a couple of times to no avail. Help will be greatly appreciated.

A:Solved: Unable to open MS Excel files

Since my previous post I have done two system restorations and neither solved the problem. BTW, I am running Windows XP Pro and the restorations were to points when everything was fine.

Read other 3 answers

Hi I set up a second User account for a friend so an office associate can sign in to access a spreadsheet on his PC.

From the Admin's account I shared to the new account with Read/Write privileges. I didn't see any higher sharing permissions but really didn't poke around much.

So I get a call from him today that associate is able to edit the spreadsheet but not save it to her account, gets an error. I'm waiting for the text of the error to google.

I'm hoping Office experts will know what else needs to be done. Did I miss an extra sharing permission?

A:Shared Excel file won't Save

The error message in detail will give us more to go with but within Excel itself it is possible to 'protect' the worksheets and/or the workbook. Have you discounted that as being the problem? Cheers.

Read other 1 answers

I'm new to this particular message board and recently, there has been an issue for my clients at my workplace who has difficulties saving their files into the remote drive on the file server (for example Drive Z:).

Everytime when they open an Excel Spreadsheet for example (my clients use
Office 2007, but some use Office 2003), they modify the data in that file.
When its time to save it, they click on "Save" and it gave them an error message that "this particular file is currently in use by another user. Please try again later."

Even though that there is no one around who is using that file remotely, they still gave the error.

The file server runs on Windows Server 2003 Standard Edition. Some clients
use Windows 7, but all others utilize Windows XP Professional.

Upon further examination, I realized that the particular version of McAfee
Virusscan is probably to blame on preventing the users who save files in
the Office 97-2003 format.

When I saved it under the Office 2007 format (i.e.
.xlsx) it worked fine, but many users want to keep it as .xls - just to maintain
cross-compatibility. I've tried to perform a registry fix for the problematic systems, but the problem persists.

By the way, based on my recent search all over the website, I heard somewhere that a version of an antivirus program was likely to blame for the drive saving issue. The file server wasn't restarted though. It kept on continuously.

The version of McAfee Viru... Read more

A:certain users in Windows 7 could not save Excel files in remote drive

Note to the administrator(s):

Permission to move this thread to the "Microsoft Office support" section of this message. Please reply ASAP.

Read other 1 answers

I have two excel files open, when I try and do a vlookup involving the two, it doesn't recognize the other workbook. Has anyone come across this?

A:Excel 2007 won't vlookup between excel files

Hi there,

Can you explain a little more? What is your formula? What are your cell values? Are you sure there is a match? Are both workbooks open? Can you post your file? If not, post as much data and detail as possible.

Read other 1 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

Ok this is a weird problem I ran into in the past with Word, and I'm having trouble finding information on it, because of the details involved.

What's happening is if i load up Excel and then goto file/open and load an excel document it comes up.

If I goto Start/Documents and try to load it from there Excel seems to hang, also if i Browse my computer and goto any excel file same thing happens, and of course it happens over a network share as well.

I didn't give it more then a minute or 2 to come up (We are talking small Excel files here nothing huge) On the last computer this happened on with Word, the documents would eventually come up, but it would take 5 minutes to load this way.

Anything I load withen Excel (Meaning I load excel and then goto File/Open, comes up instantly)

Windows knows how to handle the excel files and what program to load them with, I tried deleteing the (Is it called a mime?) entry in windows that tells excel how to handle the .XLS file, then held shift and Right clicked a .XLS file to re-enter it into Windows, just in case Windows wasn't opening it right but this had the same effect.
Any ideas?

A:Can't open excel files by double clicking, HAS to load withen excel

Read other 9 answers

I'm currently running in Windows 98 SE, My excel 2000 is currently infected by the Toraja.Gen virus, which can easily be cleaned by any Anti Virus software, but afterwards I'm unable to open any Excel related files.

A Brief Description of the Toraja.Gen Virus taken from the Symantec Web Site:
O97M.Toraja.Gen is a macro virus, which infects Microsoft Word and Microsoft Excel documents. In Word it infects the Normal.dot template, and in Excel it contaminates the \XLStart folder with an infected Excel workbook. Many standard menu functions are overridden, making them inaccessible.
It infects the Normal.dot file (Microsoft Word) or inserts a copy of the infected workbook in the \XLStart folder with the file name Start12.xls.

I already tried cleaning with McAfee Anti-Virus (Updated everyday) 3 times just in case, I also already tried uninstalling, reboot, then re-installing my Microsoft Office, but to no avail. The Excel program keeps asking me that the Start12.xls is not found everytime I tried opening a file. The only way I could open a file is by infecting my computer with the virus again. Could anybody help me out?

A:Infected by Toraja.Gen Virus: unable to open any Excel related files

After cleaning the virus, did you rename the normal.dot template normal.old or anything to force a new one to be created.

And if you run regedit navigate to this key:


do you see in the Right hand pand the Value name: Xlstart

And the Value Data: XLSTART


Did you delete Start12.xls from the xlstart folder? You might also want to search the registry for any references to Start12.xls and substitute XLSTART

If no luck, I'll move you to the Business Applications forum; I'm not really familiar with Excel and you might get better help there

Read other 2 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

I checked the May 2009 Thread and the issue was not solved. When I set up my spreadsheet, Color appeared on the drop down Filter menu. I have 8 users sharing this spreadsheet. Now the sort by color option is no longer on the menu. How do I get it back?

Read other answers

I have a problem in a clients office where three people are sharing a workbook file. One person is on 2003, and the other 2 are on 2007. For one of the 2007 users and the 2003 users the file works fine. They are able to modify save and reopen. One of the users can open a the file but if she modifies and saves the file .. next time she opens the file Excel claims there is a problem with the format, preforms a recover action on the file, and then closes. The next time any excel file is opened Excel shows the recovered xls document minus the formatting. This issue just started happening, the file has been shared between the users for about a year now. The new file has stripped all date and currency formatting. As well as filters and coloring.

Additional information: Currently no other shared files are effected.
Any help would be greatly appreciated

A:Solved: Excel 2007 corrupts shared file after saving.

anybody having the same or simular issue?

Read other 2 answers


My laptop at work has developed a nasty habit of not wanting to save work. I have an excel document say, A2, but instead of saving it as A2, an error message pops up and says the file is corrupted and I need to save it as something else.

What it does do is then save it as a tmp file.

Other times it will save the excel but open up a tmp file as well in the folder, I think today I had 17 tmp files for one excel work book.

Can anyone please advice me what is wrong? The IT dude deleted and reinstalled Microsoft office but the problem is still there.

Thanks in advance for the help.


Read other answers

How do I save a worksheet as an HTML file so I can export it it to my server? In earlier versions there was a Save As HTML option. I can't find that option in 2007 version, although I know it was preserved in the 2007 edition.



A:Excel 2007 Save As HTML

Welcome to the forums. In the older version you could do it in both the "save As" dialog box and you could do it via the "save as web page" option via the file menu. Try hitting "F12" which is save as and change the file type drop-down list at the bottom of the dialog box to web page or html. I cannot give you more specify answers since I have not used 2007 for a bit sorry.

Read other 2 answers

Hello all,

I am using Excel 2007, and whenever I save manually (Excel 2007 file, not in compatibility mode), or the system autosaves, the application crashes. I do not get an error message, but I get the "hourglass" and the application fades to white and simply hangs there. I searched the forums for a similar problem, but did not find any solutions that worked for me.

I have tried the following and none worked so far:

Disabling add-ins
Starting in safe mode
Running Office Diagnostics
Uninstalling recent Microsoft Excel updates
Reinstalling recent Excel updates
Repairing Office 2007 installation
Disabling anti-virus software

Nothing seems to work. Thanks for taking the time to read this.

I have a desktop PC, Dell Inspiron 530, Intel Core 2 Duo 2.33 GHz, 4 GB RAM, Windows Vista 32 bit.
Office 2007, SP2.

A:Excel 2007 Crashes on Save

welcome to the board.
I've read your post and when you Google "excel 2007 crashes when saving" you het a large ammount of hits.
I have no idea why this should happen and I would think it's a timeout problem but sorry, no idea

Read other 2 answers

The computer involved is using Windows 7 Pro 64bit and Office Professional Plus 2010.

I am having a problem I cannot find a solution to. I have one user at a clients location that has recently stopped being able to save excel files in their my documents. The my docs is being redirected to a server. The files open correctly and can be edited, but when save is clicked an error box says the document not saved. Using cntrl-shift-i I found the error code to be 100490. I can open any other file and save them just fine. And any new excel documents can be opened and saved correctly. The file can be saved into the same folder using save as is and the document is renamed. However, the user cannot erase the old file.

Doing some digging I made sure the trust zone was enable for the network path and trusted locations on a network were allowed. They had already been configured.

I checked for the windows update that microsoft reported could fix this problem and it was not installed. I went ahead and tried the hotfix, but it would not run because of the missing update.

I tried changing permissions and ownership. This where it gets strange the user has full control enabled on the folder. On any other folder or file I can right click and view the security tab. However, on the excel files when I click the security tab a red line is displayed that says "This file is currently not available for use on this computer." If I try to make a security change on a whole folder any excel fil... Read more

A:Cannot save excel files in a redirected folder unles I use save as

To resolve this problem, reinitialize the cache of offline files. To do this, follow these steps:Click Start, type regedit in the Start Search box, and then press ENTER.
If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.
Locate the following registry subkey, and then right-click it: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\CSC
Point to New, and then click Key.
Type Parameters in the box.
Right-click Parameters, point to New, and then click DWORD (32-bit)Value.
Type FormatDatabase, and then press ENTER.
Right-click FormatDatabase, and then click Modify.
In the Value data box, type 1, and then click OK.
Exit Registry Editor, and then restart the computer.

Taken from Gray "X" on network share folder icon

Read other 3 answers

Client has SharePoint 2010 project server.
When the user clicks on a Excel file, the file open in the browser and when the user click on "open in Excel" we receive the below message 
"To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser."
Below is the browser version 

However when the same is tried/accessed through a browser deployed on a dev machine, it works normally. Below is the version of the IE on the DEV server

What is causing this to happen?
Is there any tool to check the difference between the IE settings on my Desktop and the dev box.


Read other answers