Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

MS Excel 2007 Crashes when opening.csv files

Hi Guys
Im troubleshooting an excel issue, the user is unable to open .csv files, excel just pops up a send error report and then offers to recover the document but only recovers a blank spreadsheet.

Any ideas?
0
ihotdesk
Asked:
ihotdesk
  • 4
  • 2
3 Solutions
 
JacobfwCommented:
Excel does have know problems working with some csv files but 2007 fixed most of them.
However, can you confirm the file is local on your computer running Excel?
Have you tried opening it from a different computer?
Is it a very large file?
0
 
ihotdeskAuthor Commented:
Yes it is a local file, I copied the file to my computer via the RDP session and it opened fine, but I have Excel 2010 which could be the difference?
Size is not a factor, it happens with any .csv file.
Thanks for the reply.
0
 
JacobfwCommented:
Instead of opening the CSV file directly in Excel, try importing it. To do this, Open Excel and from the Data menu, select the "From Text" option in the "Get External Data" ribbon and try importing the file from there.

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ihotdeskAuthor Commented:
Did try that as well but it changes the format, does not display the information as it should.
And the user wants it to work as it did last week...
0
 
ihotdeskAuthor Commented:
Hi Guys
I found the issue, it was a COM add-in that was installed.
Thanks for the replies.
Cheers
0
 
ihotdeskAuthor Commented:
This was a new add in that was installed so it had to be the issue, removed it and it solved the issue
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now