Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What's the difference between an XLS and XLW file? 1

Status
Not open for further replies.
SBendBuckeye

SBendBuckeye

Programmer
May 22, 2002
2,166
US
A client has an XP Excel file that has an .xlw extension instead of an .xls extension. What is an Excel Workspace file and how is it different from a regular workbook file?

Also, in the xlw file, if you enter a date like 12/25/03 it converts it to a formula =12/25/02. Is this a bug, or is there a work-a-round.

For now, I converted it to an .xls file and it seems to be working OK. Am I missing anything here?

Thanks!

Have a great day!

j2consulting@yahoo.com
 
Sort by date Sort by votes
"xlw" workspace excel file can be either information on what workbooks to be opened and their windows, (no file contents, excel 5 or above, file>save workspace) or excel 4 workspace containing excel sheets (similar to excel workbook, but in old format, file>save as>excel 4 workbook).

To stop conversion date=>formula untick 'transition formula entry' box (tools>options, and transition tab, option for 1-2-3 users).

combo
 
Upvote 0 Downvote
Thank you very much! Enjoy your star and have a Happy New Year!

Have a great day!

j2consulting@yahoo.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top