[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Crystal Exported Excel spreadsheet causes error 1004 on link update

Posted on 2009-02-12
6
Medium Priority
?
346 Views
Last Modified: 2012-05-06
My report written in Crystal 11.5 and exported to Excel (standard export, not Data Only) causes an error 1004 'unable to read file' in Excel 2003 when another spreadsheet is opened with links to the exported spreadsheet.

I have isolated the problem to be in the exported spreadsheet.  If I open the exported spreadsheet and save it without changing anything - it works.

I have tried cleaning up the Crystal report so that all fields are aligned to margins both vertical and horizontal tabs.  Is there any suggestions how to avoid Crystal generating a problematic spreadsheet. (and exporting with Data Only is worse)
0
Comment
Question by:WilbertWaterbury
  • 3
  • 3
6 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 23624010
There are tricks to getting a good export from Crystal.

Exporting to Microsoft Excel
https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10d3ba69-951e-2b10-3093-e3cf287a57c9

mlmcc
0
 

Author Comment

by:WilbertWaterbury
ID: 23628765
I am familiar with the document and as I stated I have cleaned up the report so that it produces a well structured spreadsheet and it looks great when opened with Excel.  The report does require the use of global variables which IS cautioned against in this document.  I know what they are talking about because I've had timing problems before with 3rd pass evaluations and the data would not be correctly exported.  That is NOT the case here.

The problem is not with layout but that it causes Excel to fail with 'error 1004 unable to read file.' when linking to this exported spreadsheet. The best solution I have is to open and save the spreadsheet with no changes. That's kind of crappy.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 1500 total points
ID: 23638938
Do you export from code or the viewer?

If code you could also have the code open the report then resave it or perhaps simply making a copy will work.

mlmcc
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:WilbertWaterbury
ID: 23646999
I export from the viewer and my end user already suggested that. I was hoping to find a work around with standard Crystal.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 23651000
I don't know.  The Crystal site had an error similar but it was for CR8.5 and was resolved in CR9.

mlmcc
0
 

Author Comment

by:WilbertWaterbury
ID: 23656925
Does anyone know of a work-around for this?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

864 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