Over 1 million tech questions and answers.

opening excel 2003 documents in excel 20007

Q: opening excel 2003 documents in excel 20007

I have emailed spreadsheets created in Office 2003 to other staff members running Office 2007. They can open the attachment, work on the spreadsheet, save and close them. However, if they go back to the document later, it can't be seen. I say that deliberately; if you try to click on the document to open it, you will get the "can't open it it's already open" message. So it's there, somewhere, but nobody can see it.

I downloaded the compatibility patch from Microsoft, but no help.

What is up with this? Leave it to Microsoft to create a new program that instantly renders your old software obsolete.

Read other answers
RELEVANCY SCORE 200
Preferred Solution: opening excel 2003 documents in excel 20007

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.)

RELEVANCY SCORE 90

Hello. I have some .xls files on a cd which I could open fine until yesterday. The files were created on my Acer Aspire 5732Z (Microsoft Windows 7 Home Premium system x64 - based pc) using Microsoft Office Excel 97-2003.

Yesterday, I opened the cd on a different laptop (Acer Aspire 5733 64 bit operating system - windows 7 home premium, service pack 1). This laptop opened the files using Microsoft Excel starter 2010. I saved the files back to my cd when I'd finished, then safely ejected the CD using the correct method.

Now when I insert the CD into either pc, it show the CD drive but there are no visible files, so I can't open anything. I tried the error checking tool, but it can't check for errors as it says "windows cannot access the disk".

Can anyone help me open the files please? I have all the files backed up elsewhere, except for the two I worked on yesterday, but I really don't want to have to type them up again unless I absolutely have to as it will take me many hours. Any help would really be appreciated. Thanks in advance!
 

A:Solved: Cannot access Office excel 97-2003 .xls files after opening in Office Excel S

Read other 6 answers
RELEVANCY SCORE 88.4

My friend has a problem with Excel, basically it is opening two documents at a time? I beleive the fix is to modify the file open command by removing a duplicate ["%1"] Can someone advise how I go about this fix, I assume this would be somewhere in the Registry???

Operating system is NT
would like to know the fix for 98 if poss?

Cheers
 

A:Excel opening two documents?

What makes you say it's opening two documents?

Does it open them when you open Excel?

Does it happen on all files?

What are the names of the files?

Please don't do anything to the registry yet.
 

Read other 3 answers
RELEVANCY SCORE 87.6

I recently purchased a new computer with vista ultimate. I installed my office 2003 and it mostlly runs correctly. One major problem that I have with it is that (mostly) on start-up it will automatically start opening excel documents. It is not just one or two documents open, but more like 70-80 and sometimes the only way to get it to stop is to force a shutdown. Does anyone have any ideas of how to resolve this? It is really getting frustrating. You can't do anything while it is opening these documents.

Thanks,

Ang

A:excel documents automatically opening...

Is it opening the same document?
Are these documents in your startup folder?

Read other 3 answers
RELEVANCY SCORE 86.4

Hi all,

A user reports that each time he attempts to open some Excel documents, he receives a Visual Basic Runtime error, "run-time error 7: out of memory"

The document then typically opens as usual...and other users can open these same documents with no errors, so the problem seems specific to his machine.

Any thoughts?

OS: Windows XP SP2
1 GB RAM
Office 2007 SP1
 

Read other answers
RELEVANCY SCORE 85.6

I just upgraded my Office 2003 to Office 2007 and everything seems to be fine. The only issue I have is I double-click an Excel file on my Desktop or My Documents, it takes several minutes for the file to come up. If I have an Excel file open already and double-click another one it comes up quickly. If I open Excel first, and the click on File and Open, it comes up quickly as well.

It is only when I am opening Excel for the first time when I double click a file. I have found that when I do this it opens Excel and if I right-click, click Open and then click Cancel, it brings the document it quickly.

I have cleaned out my Temp folder and tried making changes with some File Associations but nothing speeds it up at all.

Any advice? We are going to be deploying this upgrade to about 50 users in the next couple of weeks and do not want everyone having this same issue.

Thanks!
 

A:Solved: Excel 2007 slow when opening documents

Read other 8 answers
RELEVANCY SCORE 84.8

Hi there,

I'm looking for some help please. I have just uninstalled Microsoft Office Home & Student 2007 as I prefer the Microsoft Office Professional Edition 2003. I have no problems with Access, Outlook, Word, etc. but my Excel documents in the Documents Library will not open. I get the message "C:\Users\Name\Documents\Name\doc.xls - This action is only valid for products that are currently installed". However, if I open Microsoft Excel 2003 and open the documents from there, there is no problem but I want to be able to view my documents and open them from the Documents Library. Please help. Thanks a lot.

Selbeep.
 

Read other answers
RELEVANCY SCORE 84.8

I followed a couple of expired threads on here regarding saved documents opening up blank as if you've lost everything almost like the font has been changed to white. I recently experienced this with both Word and Excel and discovered what the problem was.

It seems to be a corrupt font (verdana in my case) and selecting everything and then changing the font fixed the problem.
 

A:Saved Word and Excel Documents Opening Blank - Remedy

Indeed, to me the same thing happened a few weeks ago. He opened a document on a computer and it worked perfectly well, yet he opened it on another PC other and not working. Eventually the problem was in a font that was not properly installed.
 

Read other 3 answers
RELEVANCY SCORE 83.6

Hi All,

I created an excel using vba/formulas..etc using Excel 2007 (works).

But when I opened using Excel 2003 I got errors, (please see attached file (error2007.jpg))

so I decided to to run the 'Inspect Document' and then 'Run Compatibility Check'.

At the compatibility check I got two errors. (please see attched file (compatibilityerror.jpg))
Any ideas what the two errors mean? and how to fix them?

Thank you
 

A:Excel-Error opening in 2003

Hi,

Did you read them? The first one is regarding links to other workbooks, and it details some of the differences in previous versions and text length returns. It was in a named range of yours. This may or may not be an issue. Basically it looks for generic items and says if there is any version differences with them. If it doesn't apply to you, cool beans. But it's up to you to check it.

The second item is that of a style, which is not supported in previous versions. Some color variations may happen. If you want to avoid this, use a color that is in the previous version (either system color or RGB value). If you do not change it, the file will be opened to the closest color available.

If you are developing a file for 2003, you should use 2003 to do your developing in. If it is going to be forward compatible, cool beans. If you want backwards compatibility, start from the earliest version it will be used with. This will ensure you cover all of your compatibility bases.

HTH
 

Read other 1 answers
RELEVANCY SCORE 82.8

Excel and Word are fine if I open a blank doc from the Quick Launch bar or even My Docs. but if I try to open either from an existing doc on the desktop, it takes forever and sometimes opens empty. Also if I try to open an attachment from Outlook Express. I have tried:
1) Making sure file associations are OK
2) Re-registering
3) Repairing Office 2003
4) Running sfc

I also sometimes find that if I have this problem, then I cannot get at my drives via My Computer.

Any ideas someone????
 

Read other answers
RELEVANCY SCORE 82.8

Hello,

Suddenly, I can't open Word 2003 or Excel 2003 at all. Both programs were working just fine about 1/2 hour before I ran and installed the usual monthly Windows Updates and restarted my computer. Windows Update found some more updates (including 2 that affect the Office "conversion" toolkit). While I waited for those to install, I tried to open Word, and couldn't.

At first I thought the problem was caused by EMET 5.5, the Enhanced Mitigation Experience Toolkit, because it kept saying it detected "SimExecFlow mitigation" at the same moment Word failed to open and "stopped working". I thought EMET was blocking the Office programs.

I tried opening Word by itself, without opening a document. I tried opening Word in Safe Mode. I tried opening Excel by itself, without opening a spreadsheet. Both programs always stopped working while trying to start, and EMET always detected "SimExecFlow mitigation". I had just scanned the computer with MalwareBytes and found nothing, but I scanned the entirety of Microsoft Office in Program Files with Microsoft Security Essentials. MSE also found nothing. I restarted again after Windows Update finished the second round of installs. Word and Office still wouldn't start.

I tried using Task Manager to stop the EMET program, as a temporary solution. But even without EMET running, I still can't open Word or Excel. Word starts, and then immediately stops working and has to close. Excel... Read more

A:Trouble Opening Word and Excel 2003

Is the premium version of Malwarebytes still installed ?
If so to prove that it is the problem, uninstall the version 3.?.
Restart your machine.
Then if Word and Excel now works, I would find a copy of the Malwarebytes version 2.? and install it.
Do NOT upgrade to the version 3 as it has all kinds of issues as it include a AV and must fight your already installed AV program.
 

Read other 1 answers
RELEVANCY SCORE 82.8

Good morning all,
I am having problems opening Excel files when double clicking on all my Excel file icon, be them on my desktop, in my documents or in my network.
I initially experienced the problem of very long opening time when double clicking whereas it is very short when going the route open Excel and select "File Open" in the menu.
I solved the problem by unchecking the dde box in the "Folder Options, File Type" window.
What I am getting now is a different problem: When I double click on the Icon, the files opens immediatly (great) ...BUT it adds a "1" to the file name (it looks like it has opened a copy and has modified the filename by adding this character).
When I save the file, it opens the window "Save as" instead of simply saving the modifications to the existing file that I have opened.
Here again, if the file is open via the menu "File, Open" after opening Excel, everything is fine - no "1" added to the file name and saving is normal.
Any idea what the problem could be ?
Thanks a lot in advance.
 

A:Problems opening Excel 2003 Files

Read other 6 answers
RELEVANCY SCORE 82.8

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i5-3330 CPU @ 3.00GHz, Intel64 Family 6 Model 58 Stepping 9
Processor Count: 4
RAM: 8071 Mb
Graphics Card: Intel(R) HD Graphics, -1984 Mb
Hard Drives: C: Total - 953639 MB, Free - 817001 MB; E: Total - 715370 MB, Free - 141879 MB;
Motherboard: Gigabyte Technology Co., Ltd., B75M-D3V
Antivirus: Norton Internet Security, Updated and Enabled

I am having trouble opening any workbooks in Excel 2003.
When I click on the file up comes a blog by "Thomas Sherman" and relates to " opening-excel-files-in-new-processes-excel-launcher-helper-app/
"
Trouble only started after I was searching google to see how to auto open an excel workbook when excel was opened.
Perhaps one of the sites visited caused this problem.
I do have Excel Launcher which I know not too much about, other than that I can have several excel sheets open and they don't all close when I only want one to close.

Any suggestions on getting back to normal
Thanks
Pedro
 

A:Problem opening files in Excel 2003

Read other 7 answers
RELEVANCY SCORE 82.8

An employee recently moved here from a previous location, and brought a ton of files with her on CD, which she copied onto the PC. Now whenever she opens them, Excel says they are read only. I had her remove the read only attribute from the files if it was there. Windows claims they are not read-only and Excel says they are. What options in Excel could make a file show up as read only when the Windows attribute says it is Read-Write?

Thanks
 

A:Excel 2003, opening files as Read-Only

There is an option when you save an Excel File to turn on "Read-Only recommended", but I doubt that is the case for ALL of her files. Did you check the Folder properties to see if it it set to read-only? Maybe she copied an entire directory from the CD and the directory is now set to read-only on the local drive.
 

Read other 3 answers
RELEVANCY SCORE 82.8

Not sure if this is an Outlook or Excel problem. When receiveing an attachment of an Excel file through Outlook 2003, It changes the file name to "copy of (then the original file name)" These are new excel files not originally on this computer. Is anybody familiar with this problem?
 

A:Outlook 2003 opening of Excel attachments

leeway8,

I neither use nor know anything about Outlook or anything ending in 03.

You don't give much info about your set-up.

The only thing a search on some keywords threw up was

http://support.microsoft.com/default.aspx?scid=kb;en-us;831056&Product=out2003

HTH but highly unlikely,
Andy
 

Read other 1 answers
RELEVANCY SCORE 82

When opening large excel files, excel 2003 hangs stops responding. When taking task manager, it shows 2 instances of Excel.exe with 'not responding' status. My OS is win xp proffessional sp2. why does this happening ?? pls give me a solution ASAP.
 

A:Excel 2003 hangs when opening large files

Read other 7 answers
RELEVANCY SCORE 82

Hi there.

If I first open MS Excel from Program Files then open a file from the icon/File menu, then my files open fine and Excel loads my personal.xls file and other add-ins.

If, however, I navigate to a file via Windows Explorer and double-click to open any excel file, then it appears that the add-ins don't always load and/or Personal.xls may or may not load either.

This behaviour is always the case, i.e. never can I do it this way and opening via Explorer gives me everything I need.
It almost feels like Excel isn't being given time to load completely before the file is opened.

Does anyone else have any experience of this? Or a solution?

NB: O/S = Office XP, SP3

Many thanks
 

A:Solved: Excel 2003 - Opening file via Explorer

Following on from my previous post. Further digging around has led me to try a few things - most of which haven't worked, of course!

On one forum somewhere, for a slightly different problem, someone suggested going to Tools -> Options -> General, then selecting Ignore Other Applications.

This had the effect of not allowing any files to open via Windows Explorer.
However, after setting this back (as that was clearly not what I wanted!) I've found that files are opening as expected and correctly!

So, I don't know how/why it's worked, but the problem appears to be solved.
 

Read other 1 answers
RELEVANCY SCORE 82

Hi everyone, I'm a newbie here and needing help.

I received an excel 2007 file, I was able to open it using excel 2003 but I am unable to view all the columns, I am sure that there is no hidden columns. Help please.
 

A:Missing column using excel 2003 when opening a xlsx

If you haven't already, install the compatibility pack from here: Microsoft Downloads
 

Read other 3 answers
RELEVANCY SCORE 82

Trying to open files across a 100MB network connection.

Using Windows XP PR (Service pack 1 or 2 doesn't matter), Office 2003 Pro (w/Service Pack 1) across the network. I am trying to open Excel spreadsheets that are greater than 10MB, this either causes Excel to hang or it takes an extremely long time to load up. I also have Norton Anti-virus Corporate Edition V.9.0, but disabled that on the XP to see if it would affect the time..it did not help...
Anyone run into this?
 

A:Opening files >10MB over network w/Excel 2003

Just as a test to determine if the problem is with the network or the computer, what happens if you copy the file to the workstation and then try and open it.

Does this happen with all files on all computers, or just the large file on all computers.
 

Read other 3 answers
RELEVANCY SCORE 80.8

I have a lot of excel spreadsheets with embedded links to jpg and pdf documents stored on an NAS. In both Win XP and Win 7 I could set the file association to make them always open in the Win picture preview pane.

In Win 8.1 they will ONLY open in IE11.

I have changed the registry as directed by MS in this article to no avail.

How to configure Internet Explorer to open Office documents in the appropriate Office program instead of in Internet Explorer

Locate the subkey for the specific Office document type. The following table lists the subkeys for several common Office document types. Microsoft Office Excel 97-2003 Worksheet Excel.Sheet.8

After you identify the subkey for the specific Office document type, follow these steps:
If the Office document is an Microsoft Office Excel document, add the following value for all Microsoft Office Excel subkeys except the Excel.Sheet.5 subkey:Value name: BrowserFlags
Data type: REG_DWORD
Value: 8
Anyone else having this problem? I do not want to view them in IE which is harder to zoom, and my habits do not change as easily as MS thinks they should.

Ideas?

A:Embedded jpg links in Excel 2003 insist on opening IE11

Did you try the Fix it option ?

Read other 5 answers
RELEVANCY SCORE 80.8

When I attempt to open an Excel file using Excel 2003, the following error message occurs:

"this file is not in a recognizable format" etc...

Why does this occur, and how can I open the file successfully?
 

A:Solved: Excel 2003 - error message when opening file

Check the file extension. Am sure it has an extension ".xlsx" which means that the file was created using microsoft office 2007 excel or higher. This is why your computer does not recognize the extension of the file. the 2003 version of excel can only open files with the extension ".xls". The solution to this is to get microsoft office 2007 or higher version and install it or got the following link and download Microsoft Office Compatibility Pack and install it. it will enable you to open the file without having to install the office 2007 which may not be fit for your machine specifications.
http://www.microsoft.com/downloads/...70-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en
 

Read other 1 answers
RELEVANCY SCORE 79.6

I am trying to open a spreadsheet that was created in Excel 97 using Excel 2000. The links and macros that are on the sheet seem to prevent it from opening. There are a load of error messages but I just cannot get the thing open. I have searched so many places, found the same problem but no answer.

Can anyone help?

Leanne
 

A:Excel 2000 problem when opening Excel 97 spreadsheet with links and macros

Welcome to TSG.
Can this file be opened fine in Excel 97? Any chance that it is corrupted?
What are some of the error messages you are getting?

 

Read other 3 answers
RELEVANCY SCORE 79.2

I have an Excel page that I refer to daily and made a shortcut for it and put it on the taskbar. In windows vista the shortcut just opened when I clicked it, now with windows 7 when I click it a new Excel sheet opens. I can right click the shortcut which gives me the option of a new page or my saved page, but this is an extra step.

So, how do I get it to open after clicking the shortcut?
 

Read other answers
RELEVANCY SCORE 78.8

Hi,
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 ?
Thanks.
RB
 

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

Read other 7 answers
RELEVANCY SCORE 78.8

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...

http://officearticles.com/misc/best_install_procedures_for_microsoft_office.htm

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
RELEVANCY SCORE 78.8

We recently migrated from Office 2003 to Office 2010.

Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.

The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:

'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"

Can someone assist me with this? I need to stop it from appearing and I am not sure how.
 

A:Solved: Excel 2010 v Excel 2003 Error Valid Range

Read other 14 answers
RELEVANCY SCORE 78.8

Hi

I've recently had to get a new computer and decided to try a Mac. Everything works fine, however, I have excel files which I have transferred from my old Windows laptop which, when opened on the Mac, have not kept the colour formatting from the windows version. Is there anything I can try to see if the original colour formatting can be accessed or will I have to re-colour them all from the start?

Thanks for any help, advice, support in advance.

Wayne
 

A:Excel 2003 (Windows) to Excel 2011 (Mac) colour format issue

Hi Wayne, It's not the MAC, the issue is the fact that the newer versions of Office (also on MACS) have diffrente shading of colors.
The basic colors in Excel 2003 are not always the same.
I imagine that there is color formatting but that the shades are off, correct?

I think it will have to be hand-work, I don't know hoe Microsoft thinks about this but, well, compatability is an issue here

Maybe there's a setting somewhere that tells it to use the standaard (old version) settings, but I doubt that.

You'll need an inside-out Microsoft expert for this, I think.
 

Read other 1 answers
RELEVANCY SCORE 78.8

Im using Windows 7 and I used a macro which worked totally fine under Excel 2003. Now, under Excel 2007 it does not run anymore but displays the following error message:

"Run-time error '445':
Object doesn't support this action.

The function of the macro is to open up all other Excel spreadsheets located in the same folder and copy data out of them into the spreadsheet in which the macro is stored.

When I click on "Debug" the Visual Basic Editor highlights the row which says: Set FilSrch = Application.FileSearch

Can you help me with this? I've searched for a solution for a long time but could not find anything which worked.

The following is the start of the macro code:

Sub UpdateTable()
Dim X As Range, I As Integer, J As Integer, RecNo As Integer, CopyVal As Variant
Dim SourceBk As Worksheet, DestBk As Worksheet, StartRow As Integer, IndRange As Range
Dim ServRange As Range, SrcOpen As Boolean, SourceName As String
Dim FilSrch As Object, MyFilArray() As String

'MsgBox "This function not available in this version.", vbInformation, "Function Not Available"
'Exit Sub
'Sheets("LookUp").[a12] = Now
With Application
.ScreenUpdating = False
.StatusBar = "Counting source files ..."
End With
Set FilSrch = Application.FileSearch
With FilSrch
.NewSearch
.LookIn = ActiveWorkbook.Path
.FileType = msoFileTypeExcelWorkbooks
If .Execute > 0 Then
ReDim MyFilArray(.FoundFiles.Count)
For I = 1 ... Read more

A:Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested

Read other 7 answers
RELEVANCY SCORE 78.8

Firstly I am a beginner of beginners but I try to learn as much as I can.
I have put the following protection code into an Excel 2003 workbook and everything runs ok. I then opened the workbook in Excel 2007, and saved it as a .xlsm file. When I try to open the .xlsm file in Excel 2007, I get a vba Runtime error 13, "Type mismatch", and the code sticks at the first line below("If Worksheets...). I have tried everything that my limited knowledge allows, searched the web for 2 days, and still have no answers.
Any help would be greatly appreciated.

Private Sub Workbook_Open()
If Worksheets(28).[A51] > "" And Worksheets(28).[A50] = Worksheets(28).[A51] = False Then
MsgBox "Sorry, this program is not registered for this computer, please e-mail .......... for more info."
Application.DisplayAlerts = False
Application.Quit
End If
End Sub
My system specs are shown below.

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i3 CPU M 380 @ 2.53GHz, Intel64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 2934 Mb
Graphics Card: Intel(R) HD Graphics, 1243 Mb
Hard Drives: C: Total - 290143 MB, Free - 172186 MB;
Motherboard: Dell Inc., 0WXY9J
Antivirus: avast! Antivirus, Updated and Enabled
 

A:Solved: Excel 2003 vba code not working in Excel 2007

Read other 16 answers
RELEVANCY SCORE 78.8

I have just been upgraded to Excel 2007. I find that some of the macros that were recorded in Excel 2003 no longer work in Excel 2007. We use the Analysis Toolpak VBA add-in and I have added this in to 2007 ok, but when running a macro I get a run time 1004 error ATPVBAEN.XLA cannot be found. After some searching it would appear that some of these functions have been renamed in 2007 e.g. it is now a .XLAM file rather than .XLA which is why the macro code can't find it. I guess I could manually edit all the macros and change the fucntion names but there are other colleagues in my team that are still using 2003, so I don't want to break things for them. Is there any solution to this? Thanks
 

A:Solved: Problem with Excel 2003 macros in Excel 2007

Read other 8 answers
RELEVANCY SCORE 78.4

I'm having a problem with Excel 2000. Randomly it corrupts the file that I save to a network drive...I can save it but I cannot open it again. I get an error message "Out of Memory" It doesn't do it all the time and generally with large Excel files. I'm running Win98 and have installed all the Service Patches for both Win98 and Office 2000. Other people in the office can save to the same network drive with no problem.
 

A:Excel 2000: Out of Memory on Opening Excel Files

I would do both of the following:

Low memory (resources) error message
1. Go to "Start".
2. Then click on "Run".
3. Type in "msconfig" without the quotes.
4. Click "OK".
5. Put a check in "Selective Startup"
6. A window will open, click on the "Startup" tab.
7. Uncheck all programs that you do not need running when the computer starts.
8. These leave checked, "Sys tray" and "Scan registry".
9. Depending on your machine you might have video or sound listed also.
10. All you can do is uncheck them one at a time until you get the one needed.
11. These are programs running in the back ground and will kill your resources so you do not want any more running than you have to.

Low Memory (resources) error message with Office Application:

1. Run detect and repair in Word.
2. When it ask about rebooting to finish repairing click NO.
3. Reboot to "MS dos" prompt.
4. At the C:> prompt type in deltree /y temp\
5. Click on enter.
6. At the C:> prompt type in del *.swp
7. Reboot to windows.
8. After it reboots right click on "My Computer".
9. Then click on "Properties"
10. Then click on the "Performance" tab.
11. Then click on "File System" and set it to "Network Server" under "Typical role of this Computer".
12. Then click "OK".
13. Then click on the "Graphics" tab and set it to .
14. Click OK.
15. Rebo... Read more

Read other 1 answers
RELEVANCY SCORE 78.4

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
RELEVANCY SCORE 78.4

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
RELEVANCY SCORE 78

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
RELEVANCY SCORE 78

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
RELEVANCY SCORE 78

Does anyone know how to run Excel 2003 print macro on Excel 2007 or higher? When I tried running my 2003 macro, the VBA editor pops up w dialogue box, " Run-time error '1004': Method 'ActivePrinter' of object'_Application' failed ".

This is my code: Application.ActivePrinter = "Epson LQ-300 ESC/P 2 on USB003"

Can anyone help?

Thanks!
 

A:How to run Excel 2003 print macro on Excel 2007?

Welcome to TSG hope we can help you and you can help others.

I'm not an Excel macro guy but you code looks reasonable. What happens if you run this. I suspect printer name is a little off.

MsgBox "The name of the active printer is " & Application.ActivePrinter
 

Read other 1 answers
RELEVANCY SCORE 78

When I open a spreadsheet in Excel 2003 that was created in Excel 97, the pages with macros open with only the columns showing. It looks as if the row that appears has an infinate length. I've tried changing the row hieght, and everything else I can think of, but can't view the spreadsheet normally. Other tabs in the spreadsheet do not appear either.
 

A:Solved: excel 97 display problem in excel 2003

Read other 10 answers
RELEVANCY SCORE 78

Hi All,

Just came across a wierd problem, part of my job consists of copying data from our reports website. This normally a very simple processs, just cut and paste into excel(2003). But recently I've had a new section added to the reports website which format wise is exactly the same as previous ones. The problem is when I go to copy and paste into excel, it copies all of the data into one cell, instead of spreading it across the appropriate number of rows and columns.

I know this sound confusing but anyhelp would be greatly appreciated.

Due to the sensitve nature of the data I cannot re-create an example.
 

A:Excel 2003 - Pasting Website data into excel

is this info in a grid/table on the website?
 

Read other 2 answers
RELEVANCY SCORE 78

I purchased Excel 2007 to take advantage of the larger number of rows and columns. My SS applications are very large and I run out of columns. But after trying my Excel 2003 in the new 2007 software, I find that 2007 runs 10-20 times slower, making it completely unusable. Googling the problem shows it's a widespread issue. MS help desk essentially no help. Any suggestions?
 

A:Excel 2007 Runs MUCH Slower than Excel 2003

The biggest thing that slows Excel 2007 is also what you wanted it for - the greater number of cells. If your formulas have cell references like A:A or $1:$1, then that is a lot more cell references for it to process.
Read this http://msdn2.microsoft.com/en-us/library/aa730921.aspx and maybe you will get some ideas on how to make your files process faster.
 

Read other 2 answers
RELEVANCY SCORE 78

Hi can anybody tell me hoe to copy macros from excel 2003 to excel 2007?
The excel 2003 is running under windows xp and the 2007 under windows vista.
(The two versions of excel are installed at differnt computers)

A:Copy Macros From Excel 2003 To Excel 2007

I don't know Excel 2007 nor Vista.
But the usual way to copy macros brute force would be to open the VBA toolbar, get into the Modules, select each, and Export one by one. Then import into 2007 modules if Excel 2007 VBA permits that.
If export/import doesn't work, you can always copy out the entire text into Notepad text files, and copy/paste from the Notepad into your 2007 Excel.
If the VBA language or object model has changed between 2000 or 2003 and 2007, then some tweaking might be in order, but I suspect they left it alone, and the error messages, if any, might suggest what to fix.

Since these are different computers, either network them and share some common directory, or use USB flash drive for transfers of the, say, Notepad files.

Export is good, because it names the modules. They get saved someplace in your local settings. Notepad will not name, and doesn't matter really.

Read other 3 answers
RELEVANCY SCORE 77.2

The full error reads: There was a problem sending the command to the program.
This is actually an older Excel problem that appears to have returned with my upgrading to Windows 10.
This error is presented whenever I try to open any excel file (tried .xls .xlsm .xlsx) by double clicking on it and right clicking and selecting "Open".
I can open Excel by itself and go to FILE->Open and all the files open just fine that way.
I've tried all of the following:
Disable all COM and Excel add-insDisable hardware accelerationCheck "Ignore other applications that use Dynamic Data Exchange (DDE)", close excel, try to re-open file, accept error then go back and uncheck "Ignore other applications...", close excel again, try to re-open files againGo to registry HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open and backup/export then delete ddeexec
(completed same process for Excel.Sheet.12, Excel.Sheet.8 and Excel.Macrosheet)Go to same locations in registry but instead go to "command" key and change (Default) value from:
"C:\Program Files\Microsoft Office 15\Root\Office15\EXCEL.EXE" /dde
to:
"C:\Program Files\Microsoft Office 15\Root\Office15\EXCEL.EXE" /e "%1"
(completed same process for Excel.Sheet.12 and Excel.Sheet.8)All of the various methods mentioned here:
https://support.microsoft.com/en-us/kb/3001579
DDE method (already tried above)I don't have User Experience Virtualization (UE-V)Reset file associationsRepair Off... Read more

A:Excel error when opening documents "problem sending the command..."

Thanks to the marked solution from the site below, I was able to get things working again.
Windows 7 - Cannot run multiple instances of excel using option

The site says to check the DDE option in Excel first. I found that it doesn't matter whether you do this or not. Having the box checked or unchecked appears to have no effect on anything for me. (I ended up leaving it unchecked because that appears to be the consensus of the state it "should" be in on most sites I found)

So the solution for me ended up being sort of a combination of two of the methods I had tried before:
In the registry editor (win+r then type regedit) go to the following location:
HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\OpenBackup before you change by right clicking on "Open" and selecting "export"Either delete or rename "ddeexec"
(renaming to ddeexecOLD or ddeexecBAK helps you remember that you changed something in the registry if you ever have to come back to this location again)Select "command" then modify the "(Default)" entry by replacing /dde at the end of the string with "%1" (with the quotes and a space before the "%1").
Changing /dde to /e appears to have no effect, all that was needed was the "%1" at the end. Repeat the above process replacing Excel.Sheet.12 with any/all of the following that are applicable to you:
Excel.CSVExcel.MacrosheetExcel.OpenDocumentSpreadsheet.12Excel.Sheet.8Excel.SheetBinary... Read more

Read other 13 answers
RELEVANCY SCORE 76.8

Hi All,

I work on a web application that has Excel and Word documents in it.

At the moment when a user opens these documents in IE9 they get presented with a dialog box asking:

What do you want to do with "filename"?

The user is presented with Open, Save and Save As as the options.

Unlike previous versions of IE there is no check box to tick to remember the user's choice so it comes up every time.

I really need to get rid to this box. Does anyone know how to disable it?

Thanks

Tom

A:How to get Excel and Word documents to open without the Open,Save,SaveAs box opening

Hello and welcome to the forum.

Click Start => My Computer => Tools => Folder Options => Click on File Types tab => In the file types list => click Excel => click Advanced => UNcheck clear the Browse in same window check box (or click to clear the Open Web documents in place check box) => Click OK

Read other 3 answers
RELEVANCY SCORE 76.4

Why does the second line of the code shown below produce an error in Excel 2007 and not in Excel 2003? The error is:
Run Time Error 1004, Unable to set the Text Property of the Characters class

ActiveSheet.Shapes("btnJobSummary").Select
Selection.Characters.Text = "Prepare Job Summary" & Chr(10) & "for " & CurrentJob

CurrentJob is defined as: Public CurrentJob As String

In this case it equals: RockMont Rev 7-9-04

No problem at all in Excel 2003 and earlier. If CurrentJob is something shorter (e.g. MyFile), there is no error. I don't think the spaces are a problem either because I still got the error after adding Chr(34) before and after CurrentJob in my code. Any ideas? Thank you.
 

A:Error in Excel 2007 but not in Excel 2003

Hello, welcome to the board!

The text is too long. Use an ActiveX control instead of a Forms control. Then you can use similar code...
Code:
Public Const strCurrentJob As String = "RockMont Rev 7-9-04"
Dim btn As CommandButton

Sub FooTest()
Set btn = Sheet1.CommandButton1
btn.Caption = "Prepare Job Summary" & Chr(10) & "for " & strCurrentJob
End Sub
HTH
 

Read other 3 answers
RELEVANCY SCORE 76.4

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
RELEVANCY SCORE 76.4

Hi All,
I don't know if I'm posting in the right area but I really need help.
Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program)
With Windows 7, when I open a different file, it opens another excel program (2 files in 2 excel)
Is there a way to combine the files into one excel?
I was reading through the forum and someone mentioned about Option->Tools->View->Windows in Taskbar but this doesn't work....
Help experts.......because of this, vlookup, etc...are not working....

Thank you.

Dave.

A:Excel 2003 - Multiple Excel Open

Found the solution....

Create file with:

HKEY_CLASSES_ROOT\Applications\EXCEL.EXE]
[HKEY_CLASSES_ROOT\Applications\EXCEL.EXE\shell]
[HKEY_CLASSES_ROOT\Applications\EXCEL.EXE\shell\open]
@="&open"
[HKEY_CLASSES_ROOT\Applications\EXCEL.EXE\shell\open\command]
@="\"C:\\Program Files\\Microsoft Office\\Office11\\EXCEL.EXE\" /e"
[HKEY_CLASSES_ROOT\Applications\EXCEL.EXE\shell\open\ddeexec]
@="[open(\"%1\")]"
[HKEY_CLASSES_ROOT\Applications\EXCEL.EXE\shell\open\ddeexec\application]
@="Excel"
[HKEY_CLASSES_ROOT\Applications\EXCEL.EXE\shell\open\ddeexec\topic]
@="System"

save file as name.reg (not name.reg.txt)

run file and done.

Read other 1 answers
RELEVANCY SCORE 76.4

Hello,

I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns.

It's a cinch when drawing a table in MSWord (2003) so I cannot imagine why this should not be possible in Excel, but then I don't know everything

Thank you

A:Formatting Excel 2010, Excel 2003

If I understand your problem then it is quite simple. Assuming A1 has the "heading" then select thsi cell and all the other cells in row A which pertaim to the tanle and then "merge the cells" and centre the title. I forget how this is done in Excel 2003 but I do remember it being available on the screen on the Edit toolbar I think.

Cheers

Read other 5 answers