Modify Xlsx Files With Excel 2003
|
|
Search Excel Forum Posts, Tutorials, Macros, Tips, and More
I have some files saved as xlsx with Office Beta 12. I need to be able to
read and modify these files with Excel 2003.
Is it possible? How?
Thank you in advance
Similar Excel Video Tutorials
Names in Excel 2003 & 2007
- Learn the basics of how to create and use an Excel Name in Excel 2003 & 2007. See how some names from Excel 2003 are not allowed in 2007! See the ...
Similar Topics
Hi all,
I've recently upgraded my Office from 2003 to 2010. I have a drive which contains many folders and many files. All files in the folders are in .xls format and does not contain macros.
Usually, I convert a Excel 2003 .xls file by going to File > Info > Convert, but that I've to do it one by one.
I've about 100+ .xls files in my drive. Does anyone know how to mass convert the .xls files to .xlsx files?
I think I can't just change to file extension from .xls to .xlsx as I couldn't open the .xlsx file anymore.
i was using the beta version of office 2007, My licence expired, how do i
convert .xlsx files to microsoft office worksheet in office 2003 (excel)
I HAD THE 2007 BETA AND WHEN I WAS DONE WITH IT I TRIED TO GET MY FILES BACK
TO MY ORIGINAL EXCEL 2003 FILES AND I AM HAVING SOME TROUBLE DOING THAT. IF
ANYONE COULD HELP THAT WOULD BE GREAT.
Hi, I have an odd problem I've been unable to find elsewhere on the internet. I recently upgraded to Office 2007 from 2003. Any .xls files I have still work just fine as do any .docx and .pptx files. But for .xlsx files, they do nothing when I double click them. There's no error message, just nothing happens. To open them I have to open excel manually and drag the file into the window, which is really frustrating when trying to open files in email attachments since I have to save them first.
Does anyone know why Excel won't just open them on a double click? I set the default program to open it with as EXCEL.exe. I deleted all the registry entries associated with .xlsx but it didn't change anything. Any ideas you have would be appreciated.
Thanks,
Tim
We've had an update apparently installed on our PC's today, (Our IT Guys are pointing the finger at Microsoft, )
And we are finding that in VBA we are having issues with
R1C1 referencing
Saving files as XLSX, it seems to be defaulting to xls
Keep getting an error message about cells having duplicate names - (but we didnt give them names!)
any one else having issues, had an upgrade cause issues lately?
Saving solution found:
The problem appears to be where the coding “ActiveWorkbook.SaveAs Filename:=[file name.xlsx], FileFormat:=xlNormal” is used. This is a bit of a throwback to Excel 2003 as evidently “xlNormal” is not a recognised FileFormat in Excel 2007.
However, up until yesterday, files with an .xlsx postfix saved using this methodology were saved correctly as 2007 files. I’m not sure what has changed, but this morning files saved using this methodology were saved as 2003 files with a 2007 postfix (i.e. .xlsx)... Cue error messages about corrupted files!
The fix is easy enough... If you are saving a file in 2007 as an xlsx file, simply omitting the “, FileFormat:=xlNormal” phrase seems to fix the problem.
recently i've been receiving excel files with 'xlsx' extensions, (not xls) and when i try to open i get a message 'can't read', i'm running microsoft office excel 2003...any suggestions?
I have written an application in Java that used POI to import Excel files, in either Office 2003 format or Office 2007 xlsx (OOXML) format. The issue I have run into is that some files that have the 'xlsx' extension appear to be in 'xlsb' format, this despite the user having specified the file to be saved in 'xlsx' format. I would like to understand why this is happening.
Can anyone tell me whether there are any reasons that would cause Excel 2007 to save the file in the binary format, rather than the OOXML format? I don't if it is any indication, but when trying to open the file in Office 2008 (Mac) I get told that the workbook contains unsupported "OLE DB query tables" content. I am reaching the conclusion that this is the binary format, because the file data does not start with "PK" characters and saving another file in xlsb shows the same general pattern.
I have a lot of Excel 2003 files. Some quite large. I have Excel 2007 /Vista and they will not open. I have gone to another machine and re-saved them in .xlsx format, and .xlsm and they still will not open in excel 2007.
The error message says the format is not valid.
I've run MS Office diagnostics and all is ok.
I also tried viewing the files in Excel Viewer, same result though
Any ideas?
Thanks
Hi
Seems we are behind the times here, but, I am being sent Excel Files in xlsx which is fine however I have Excel 2003 and it wont open is there an add in or patch that will help me open these files and then save as Excel 2003?
Hello!
My firm has finally started to upgrade to Excel 07. We have a lot of excel files that are .xls and I was wondering if there are any problems if you just start saving the old files as .xlsx instead. I know that in 07 you go out to 3 letter columns (AAA) so you can't have names in .xls that are ABC or something, but are there any other issues I should be aware of? Is it still ok if the new .xlsx still links to old .xls files and has match(index) formulas that look up old .xls files?
Has anyone encountered unexpected problems converting .xls to .xlsx?
Thanks!
Hello all.
I stumbled upon an issue with one of my end users computers. They are running Office 2003 with the Compatibility pack. I'm trying to get them to have the ability to open and edit .xlsx files. Originally, the file was not viewable until I installed the compatibility pack, along with the excel viewer. Now they can view the .xlsx file with the Excel viewer. I then tried to open the file with Excel and I'm still getting the following error message:
http://i33.photobucket.com/albums/d7...k/Picture1.png
If I click on ok or cancel, the information in the file turns to a bunch of code. There is nothing wrong with the file because it opens fine on my pc. I ran a complete uninstall and then reinstalled Office. Still getting the same error. I would appreciate any suggestions.
Thanks!
Hello all.
I stumbled upon an issue with one of my end users computers. They are running Office 2003 with the Compatibility pack. I'm trying to get them to have the ability to open and edit .xlsx files. Originally, the file was not viewable until I installed the compatibility pack, along with the excel viewer. Now they can view the .xlsx file with the Excel viewer. I then tried to open the file with Excel and I'm still getting the following error message:
http://i33.photobucket.com/albums/d7...k/Picture1.png
If I click on ok or cancel, the information in the file turns to a bunch of code. There is nothing wrong with the file because it opens fine on my pc. I ran a complete uninstall and then reinstalled Office. Still getting the same error. I would appreciate any suggestions.
Thanks!
I am currently using Excel 2003, but am planning to buy a new computer and upgrade to Office 2007/2010. My clients are still using Excel 2003, so I must have my files compatible for their use. What's the best/simplest way to do this? Will the files retain their current 2003 extension, or will I need to modify them?
I have a problem with some VBA code. I have a routine that does a Save As. It does a Save As twice. That is, in the first Save As dialog box that comes up, the Save as Type is: Excel Files 1997-2003(*.xls). In the second Save As dialog box, the Save as Type is: Microoft Office Excel Workbook(*.xls). All fine and well. When I click 'Save' on both instance, it saves both files to my documents folder. However, when one of my collegues tries this, the first file doesn't get saved, but the second file is saved and shows up in his documents folder. Why does it work for me and not on his computer? We have the same version of MS Office 2003. Is there something else going on here? This is what the code looks like:
Code:
Sub SaveNewFile()
Dim FileName as String
With Application
.ScreenUpdating = False
.EnableEvents = False
End With
FileName = "TestFile" & ".xls"
FileExtension = "Excel Files 1997-2003 (*.xls), *.xls," *_
"Excel Files 2007 (*.xlsx), *.xlsx," & _
"All files (*.*), *.*"
NewFile = Application.Get:=SaveAsFilename( _
InitialFileName:=FileName, _
fileFilter:=FileExtension)
If NewFile <> "" And NewFile <> "False" Then
ActiveWorkbook.SaveAs FileName:=NewFile, FileFormat:=xlNormal
End If
End Sub
Hi Guys,
I have case where there are excel files arranged like this within a folder. For example:-
XA11_df01.xlsx
XA11_df02.xlsx
XA11_df03.xlsx
.
.
XB11_df01.xlsx
XB11_df02.xlsx
.
.
YA11_df01.xlsx
YA11_df02.xlsx
.
.
YB11_df01.xlsx
YB11_df02.xlsx
.
.
All these files are located in one folder. I want to write a macro to open the latest excel files based on lastmodified date and time for each file name like XA11, XB11, YA11, YB11. I only want to do this for excel files (".xlsx") within a folder as there are other pdf files also in the folder. I want macro to open the latest file for first file name run my code on it , then open latest file for second file name and run my code on it so on.
Any help will be highly apprecited.
Thanks.
Roop
Is there any method or software which will convert all old XLS files (excel 2003) to XLSX (Excel 2007) without any hassel at one go or one by one manually.
I have some files in old version which needs to be converted since it is going beyond column IV.
Thanks n rgds
Shyam
Hi
I have Excel 2003 and 2007 installed on my pc -I need both. I can open files in either by opening from within the application. But when I open files through Windows Explorer by double-clicking - it always opens the files in Excel 2007.
Is there a way to get xls files to open in 2003 and xlsx files to open in 2007 from within Windows Explorer?
I have set the default file types correctly but they still always open in 2007.
Thanks for your help in advance!
After spending an hour trying to figure this out I need some help from the experts. I have office 2003 installed on my computer. About 3 months ago I bought Office 2007 and put that on the PC as well. Whenever I clicked on any of the old xls files I had saved they always opened in office 2007 compatibility mode which was nice. Well last night windows installed some update and now every time I open one of these files they are opening in 2003. Is there a way to change that back to opening the files in compatibility mode by default?
Thanks in advance.
i have many files created with the 2003 edition when i can modify all the graphics.
I migrated in 2007 version and now i can't modified nothing in any sheet where i put the graph.
If i create a new sheet containing a graph, in 2007 versione , i can modify all without problem...
Someone can help me ??
I have to download files from a database and save them in .xls format (the only format permitted to export from the database)
Anyone have a macro to:
Given an open excel wb saved to my hard drive (or network drive) in non .xlsx format. (most likely .xls)
Switch the file to .xlsx format without loosing the open file. (re-open ok).
Caveats:
-Don't want two files
-Dnn't want to have the file name changed (except for the extension).
-Don't want to remain in compatibility mode.
-Don't want to wait a long time.
-Don't want to have possibility of file corruption.
I just want to take my non .xlsx file and then, turn into a .xlsx file. (if I save the file as .xlsx I am still in compatibility mode until I re-open the file. I also will have two files---very annoying).
Thanks in advance
I have several older excel files (xls) that I have saved as "xlsx" files but the max rows still stay at 65,536. How can I increase the number of rows in these files to the new max number of 1,048,576? Thanks for any assistance you can provide.
Denny Riffert
Evansville, IN
WMDC imports all my Word and Excel files (I have over 1200 on my pda) in ppc format (pws and pxl). I thought it was the fault of Office XP vs Vista (I could read those files fine on Office XP)and that when I bought Office 2007 I'd be able to read the ppc files on my PC. No such luck. It will import rtf files, so I've translated literally hundreds of doc files into rtf format; however I don't see any workaround for the spreadsheet files. I even tried open office on my Vista machine. It won't read those files either.
I'm running ppc 2003 on an iPAQ 2755. Have been using them FINE for over a year on XP and using various versions of ActiveSync.
I'm close to paying the computer shop that built my machine for me to put XP on my brand new machine unless I can get some answers.
Is there any way to get Microsoft to talk about these problems for brand new software? Or does anybody have any suggestions how to read my excel files that I sync from my pda to my pc?
Help,
Patrick
All,
I have been looking round and have come back to you guys to give me some advice, I am looking for a way to bulk convert a number of xls files to xlsx format, as i have noticed that xlsx files are around 3 times smaller than xls files.
I am thinking that some sort of macro which file by file opens the file, saves it as an xlsx (2010) file and then deletes the original.
I know that a number of my files are quite small but there are a number which are around 100mb, and these very quickly add up to many Gb.
If anyone can help or point me in the right direction i would be really greatful
Thanks
Hi Everyone,
I've recently been using a database for downloading vast amounts of stock data at work. The stupid thing is that on the database station, there's only Excel 2003 so the xls files take up tons of space. After I save them in xls, I have to go to a different computer and convert (save) each file in the xlsx format to save up space and make opening/closing/working with the files faster. I have to this once, sometimes twice daily. My question is: is there a way to select all (for example 20 files) at once and convert them to xlsx or I have to do it manually for each one. Thanks for your help!
The converter to convert .xlsx files to .xls quit working. I can no longer open .xlsx files. I've uninstalled and reinstalled office, and excel several times. I bought and used a registry cleaner after each uninstall. I've moved the location of new installation of office to a different directory. Each time trying to reinstall the converter. At each attempt I get a message that a current version of the converter already exists and I need to uninstall it to reinstall it. I've uninstalled everything I dare uninstall yet the problem remains. What do I uninstall to get rid of the problem? I'm not a novice nor stupid. I've tried the repair option in the control panel add and remove area. I'm still at square 1.
Should I uninstall msxml 4.0 sp2? Should uninstall anything that has ms in it?
Can anybody help me?
