Report from an Excel sheet - how to refresh the link?

[matpj]

I am running a Crystal Report from an Excel Spreadsheet, but I have included anew column on the spreadsheet that I would like to include in the report.
How can I update Crystal with the new columns?
When I try to refresh the connection nothing happens...

 

[GJParker]

What connection method are you using ?

I have just tried a test using a DAO connection to the spreadsheet, If I alter the spreadsheet and then use Verify database the new column appears.

Gary Parker
MIS Data Analyst
Manchester, England

 

[matpj]

How can I tell what connection it is??

All I did was click on the CR icon within Excel...

 

[GJParker]

Mat

from what I can see, when you create a report this way, because you specify a range of cells when you create the report, this is retained as the data range

You will need to use teh set Database location option and replace teh current retained location with the worksheet location this should bring in any new columns you have created.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[Hexcot]

Hi,

You can reassign the previous selection by again going to the Tools -> Crystal Report Wizard.

Let me know for any problem..

Bhavesh