Cruisers Forum
 

Go Back   Cruisers & Sailing Forums > Scuttlebutt > Dollars & Cents
Cruiser Wiki Click Here to Login
Register Vendors FAQ Community Calendar Today's Posts Log in

Reply
  This discussion is proudly sponsored by:
Please support our sponsors and let them know you heard about their products on Cruisers Forums. Advertise Here
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 29-01-2019, 05:30   #1
Registered User

Join Date: Jul 2006
Location: Underway in the Med -
Boat: Jeanneau 40 DS SoulMates
Posts: 2,274
Images: 1
convert excel spreadsheets xlsx to xls

Can someone give me a hand please - I just finished our review of 2018 cost and want to put out our 10 years of cost data - but the system does not allow a XLSX file only a XLS file.

How do I manage this.

thanks
chuck
__________________
just our thoughts and opinions
chuck and svsoulmates
Somewhere in the Eastern Caribbean
chuckr is offline   Reply With Quote
Old 29-01-2019, 05:49   #2
Registered User

Join Date: Aug 2018
Posts: 500
Re: convert excel spreadsheets xlsx to xls

Chuck,

You are probably using an old version of Excel. Is there a read you need the newer format (xlsx)? You should be able to open the XLS version on the old and the new.
B23iL23 is offline   Reply With Quote
Old 29-01-2019, 05:56   #3
Registered User
 
svHyLyte's Avatar

Join Date: Mar 2006
Location: Tampa Bay area, USA
Boat: Beneteau First 42
Posts: 3,961
Images: 25
Re: convert excel spreadsheets xlsx to xls

See (click on) MS Excel File Conversion
__________________
"It is not so much for its beauty that the Sea makes a claim upon men's hearts, as for that subtle something, that quality of air, that emanation from the waves, that so wonderfully renews a weary spirit."
svHyLyte is offline   Reply With Quote
Old 29-01-2019, 05:57   #4
Registered User
 
Reefmagnet's Avatar

Join Date: May 2008
Location: puɐןsuǝǝnb 'ʎɐʞɔɐɯ
Boat: Nantucket Island 33
Posts: 4,864
Re: convert excel spreadsheets xlsx to xls

As above, but if you really need xlsx format and you have a windows live account you should be able to open it in office online and save as to that format.
Reefmagnet is offline   Reply With Quote
Old 29-01-2019, 06:15   #5
Registered User

Join Date: May 2017
Location: Katy, TX
Posts: 404
Re: convert excel spreadsheets xlsx to xls

When you do a "save as", there's a drop down box that will allow you to select different file types. If you have an .xlsx file that you want to save as .xls, just select that file type and Excel will convert it.

You will receive a warning message that some features will be lost. If you've used calculations or features available in an .xlsx file type but not available in a .xls, you will lose that, but generally this shouldn't be a problem as most of the features not available in .xls are in regards to VBA and macro programming.
Attached Thumbnails
Click image for larger version

Name:	Capture.JPG
Views:	83
Size:	20.9 KB
ID:	184714  
leboyd is offline   Reply With Quote
Old 29-01-2019, 06:52   #6
Registered User

Join Date: Jul 2006
Location: Underway in the Med -
Boat: Jeanneau 40 DS SoulMates
Posts: 2,274
Images: 1
Re: convert excel spreadsheets xlsx to xls

Thanks everyone -- got it
__________________
just our thoughts and opinions
chuck and svsoulmates
Somewhere in the Eastern Caribbean
chuckr is offline   Reply With Quote
Old 29-01-2019, 16:31   #7
srt
Registered User

Join Date: Dec 2014
Location: Fremantle
Boat: Hunter 40
Posts: 20
Re: convert excel spreadsheets xlsx to xls

Libreoffice is a free download and very useful program for spreadsheet and document file conversions. It will allow you to open and create in any of the formats you are likely to want.


https://www.libreoffice.org/
srt is offline   Reply With Quote
Reply

Tags
sheets


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
For Sale: Samson XLS Yacht Braid 3/16" New jdisarro General Classifieds (no boats) 3 07-10-2018 10:17
Spreadsheets ozboatie General Sailing Forum 0 14-03-2010 01:58
Expenses: Excel Spreadsheet, Please MarkJ Dollars & Cents 19 22-12-2009 03:27
Excel Provisioning Spreadsheet SV Someday Came Cooking and Provisioning: Food & Drink 52 27-07-2009 15:14

Advertise Here


All times are GMT -7. The time now is 20:13.


Google+
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Social Knowledge Networks
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.

ShowCase vBulletin Plugins by Drive Thru Online, Inc.