Solved

Excel and what codepage to use when opening a csv file?

Posted on 2014-11-16
9
321 Views
Last Modified: 2014-12-09
Hi, when opening a csv file in Excel 2010 (also in 2007, but i upgrade to 2010 and still same problem) where could i set what codepage to use as default? If i import it and change from Windows (ANSI) to MS-DOS (PC8) its shows correct, but when opening a file it dont shows correct character set. This is from a progress (openedge) program and the file is a link so i must first open it in Excel, save it localy and then import it, but i want to show correct character set when opening it. Is it possible to set somewhere in Excel 2010 that the default codepage to use when opening csv file is MS-DOS (PC8) ??  There is only one pc that have this problem, 4-5 other pc shows correct charset when opening. All have Norwegian Windows 7 Pro and Norwegian Office 2007 and some have Office 2010, so its only one pc that have this problem.
0
Comment
Question by:per-w
  • 5
  • 4
9 Comments
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
What I can think of very quickly is change the extension from .csv to .txt and the Import Text Wizard should kick off letting you change whatever you want.
gowflow
0
 

Author Comment

by:per-w
Comment Utility
The problem is that the file is opened from a progress (openedge) program, the save and then open is not an option for the user. But since this is a problem on one computer there must be some settings somewhere?
0
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
Well I looked at to see a setting but could not find.

What do you mean by:  file is opened from a progress (openedge) program ...
Just before the user accessed the file, manually change its extention to .txt open the file in Excel do what you want save it then let the user access it

gowflow
0
 

Author Comment

by:per-w
Comment Utility
There is 150 users, every users access a excel file from Progress (OpenEdge) that they use as a order/crm software. The users dont know how to save and rename files, they got a link in the program that they click on many times a day. One user have problem so there must be some settings for this.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 29

Expert Comment

by:gowflow
Comment Utility
Fine
1) What is the Excel version of users who don't hv problem and their machine OS
2) What is the Excel and the OS version of the culprit machine

gowflow
0
 

Author Comment

by:per-w
Comment Utility
All have Windows 7 Pro 64 bit, Norwegian
Some have Office 2007 but most of them have Office 2010 (all 32 bit) Norwegian

The PC with problem did have Office 2007 32 bit Norwegian, but since it had problem the Office was uninstalled, then Office 2010 32-bit Norwegian was installed, but same problem.
0
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
ok when 2010 installed
1) Did all office update performed ?
2) Did all related windows update performed ?

It is very important when you install software that you make sure you keep activating windows update up until there is STRICTLY no more updates as maybe this issue was resolved in one of the updates. I see no reason why it is working with lots using the same file and not working for 1

gowflow
0
 

Accepted Solution

by:
per-w earned 0 total points
Comment Utility
New PC solved the problem. A reinstall would have done it to i think, but old pc so cheaper to buy new pc.
0
 

Author Closing Comment

by:per-w
Comment Utility
Not possible to solve the problem.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now