Does Renaming a Converted Excel File Affect Its Content?

  • Thread starter Thread starter jojoba
  • Start date Start date
Click For Summary

Discussion Overview

The discussion revolves around the implications of renaming a converted Excel file, specifically from the 2007 version to the 2003 version, and whether this action affects the content of the file. Participants explore aspects related to file compatibility, features lost during conversion, and methods for ensuring proper display of data and charts.

Discussion Character

  • Exploratory
  • Technical explanation
  • Debate/contested

Main Points Raised

  • One participant questions whether renaming a converted Excel file affects its content, indicating uncertainty about the process.
  • Another participant asserts that losing 2007-only features occurs during conversion, not renaming, suggesting that renaming does not impact the file's content.
  • A participant expresses concern about the display of a file converted from .xlsx to .xls using an online converter, seeking confirmation on data visibility and plot accuracy in compatibility mode.
  • A later reply advises against using online converters, recommending instead to use the "Save As" function to ensure proper format compatibility and suggests exporting charts as graphics or PDFs for consistent display.

Areas of Agreement / Disagreement

Participants do not reach a consensus on the best practices for file conversion and display, with differing views on the reliability of online converters and the implications of renaming files.

Contextual Notes

Participants mention specific features and compatibility issues related to different versions of Excel, indicating that the discussion may depend on individual software setups and user needs.

jojoba
Messages
12
Reaction score
0
Hi,
This is a stupid question, but I just had to ask it:
I had an excel file made using MS 2007 version and had to convert it to 2003 version. I renamed the converted file once saved on my PC. Does that (renaming) change anything in the converted file?
 
Physics news on Phys.org
You lose all the 2007-only features. But you lost them when you did the conversion, not the renaming. If you want to keep it standard, either avoid 2007 features, or just install the compatibility pack on your Office 2000, 2003, or XP computers:
http://www.microsoft.com/downloads/...70-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

NOTE that this pack just allows you to open .docx or .xlsx files, and save the same WITHOUT OFFICE 2007 ONLY features!
 
Last edited by a moderator:
Thanks Matlab a lot. I have converted the following file from .xlsx to .xls using an online converter... I am not sure if it is going to be displayed correctly in the compatibility mode. Would someone please open this and tell me if you see the data and the stress vs. strain plot?
Thanks again
 

Attachments

jojoba said:
Thanks Matlab a lot. I have converted the following file from .xlsx to .xls using an online converter... I am not sure if it is going to be displayed correctly in the compatibility mode. Would someone please open this and tell me if you see the data and the stress vs. strain plot?
Thanks again

Nobody (in their right minds) is going to open that. Forget using the converters, just go File > Save As and save in Excel for Office 2000 / 2003 XP format. If you want a chart to show up the same regardless of who's looking at it, export it as a graphic or use Acrobat to print it to a .pdf file. There's also the program I use, PDF Creator, which acts as your plain jane PDF maker:
http://sourceforge.net/projects/pdfcreator/

TIP: When you make your chart, have it plot in a new window, not embedded within a page of your spreadsheet.
 

Similar threads

  • · Replies 15 ·
Replies
15
Views
3K
  • · Replies 20 ·
Replies
20
Views
3K
  • · Replies 16 ·
Replies
16
Views
6K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 12 ·
Replies
12
Views
11K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 7 ·
Replies
7
Views
4K
  • · Replies 2 ·
Replies
2
Views
12K
  • · Replies 22 ·
Replies
22
Views
3K
  • · Replies 1 ·
Replies
1
Views
4K