I am building a friend's new computer, and have put Microsoft Office on instead of Microsoft Works + Microsoft Word, so I need to convert all his Microsoft Works spreadsheets to Microsoft Excel.
How do I convert a Microsoft Works spreadsheet (*.wks) to a Microsoft Excel spreadsheet (*.xls)?
when you're saving, check the drop down menu that shows what file type it should be.
It's below the file name
Reply:there isn't any need to convert any files.
Reply:If any of the above options fail, you could always open both applications at once and copy and paste the entire sheet from one to another....
Reply:when in works spreadsheet go to save as under the file category and go to save as type and a *.xls category should b there.
Reply:You could try using a copy of the spreadsheet supplied free at www.openoffice.org This is a fully legit set of office programs that many corporations use. Using the "calc" program which is the equivalent to Excel, you may be able to open the Works file- It would then allow you to save it as a variety of formats, obviously Microsoft Excel being one of them. Good luck! I hope it works,
Reply:There really isn't any need to convert the *.wks files to *.xls files as Microsoft Excel has the ability to open those types of files without having to do anything. What you need to do is go to File and Open and in the drop down menu for Files of Type: scroll down until you find Microsoft Works files.
If you want all *.wks files to be associated with Microsoft Excel so they open automatically in Excel try double-clicking on one of the files and it will prompt with what program you would like to open that file with. Select to select a program from a list. Chose to open the file with Excel but check the box at the bottom of the screen that says Always use the selected program to open this kind of file.
More info:
If just trying to open the file with Excel I would say that you need to specifically choose to open a Microsoft Works file or *.wks since Excel will need to know what format the file is in and open it accordingly. Excel can also open Quatro Pro files but if you don't specify that the file is Quatro Pro then it may not work properly.
I have a machine that has Office 2000 on it. If this approach still does not work please let me know and I can try it on that machine. Email me if this is the case and try attaching one of the files I can look at.
Additional Info(9-20):
I have been doing some research and I have found that you cannnot directly open Microsoft Works 3.0 or 4.0 files directly into Excel. Excel will only open Microsoft Works 2.0 or earlier format. Below is a Microsoft knowledgebase article describing the problem and how they have decided to address it. It would appear that you are going to need Microsoft Works installed to change the file format to something Excel will recognize before you make the move to Office.
sensitive teeth
No comments:
Post a Comment