csukardi151
New Member
- Joined
- Jun 19, 2012
- Messages
- 6
Hello,
I'm having a crystal report automatically export to excel once a day. I wanted to create a new excel workbook that pulled certain data from this file and create some graphs. I am using the formula:
"='s:\folder\[excel.xls]Sheet1'!A1"
Here's the catch, this formula does not work right away. In order to get it to work, I need to open the excel document that was exported from crystal reports and click the save button (without making any changes). Once I did that, the formula will work no problem.
Is there a way I could get around this? An alternative way to do what i'm doing? I really just want to create an excel file with a few graphs that is automatically updated when opened, which is why I wanted it to pull data from the exported file that is updated once a day.
Thanks in advance,
Steve
I'm having a crystal report automatically export to excel once a day. I wanted to create a new excel workbook that pulled certain data from this file and create some graphs. I am using the formula:
"='s:\folder\[excel.xls]Sheet1'!A1"
Here's the catch, this formula does not work right away. In order to get it to work, I need to open the excel document that was exported from crystal reports and click the save button (without making any changes). Once I did that, the formula will work no problem.
Is there a way I could get around this? An alternative way to do what i'm doing? I really just want to create an excel file with a few graphs that is automatically updated when opened, which is why I wanted it to pull data from the exported file that is updated once a day.
Thanks in advance,
Steve