Help in creating Excel Dashboard

[Webtechie]

I ma creating a dashboard in Excel. On my dashboard sheet, I will have about
5 embedded charts side by side.

Next to the last embedded chart, I'd like to put an Access report/.

I've tried to insert a link. It only puts a icon which links to the whole
database.

It is possible to insert an Access Report into Excel, much like you can
insert an Excel Chart into a Word document?

Thanks,

Tony

 

[Sean Timmons]

you can export the report to Snapshot format, then link to the saved report
using a hyperlink...

 

[Webtechie]

Sean,

I tried that. I got an icon on the spreadsheet that didn't do anything. I
don't want an icon. I want the actual report. When you link an Excel Chart

 

[Sean Timmons]

If you saved the file to a drive and hyperlinked to it, you would have a
hyperlink, not an icon. Exporting in Snapshot format allows the file to open
with same formatting as in the Access report, though it would open in the
snapshot application rather than within Excel.

You can export as an Excel document, though it loses any formatting you may
have on it. At that, you'd probably be best making a query and using Data >
Import External Data and performing an Access Database Query.

this is all to say it won't look like a chart embedded in Word, so you'll
need a workaround.

 

[Webtechie]

Thanks. I will come up with a workaround.

If you saved the file to a drive and hyperlinked to it, you would have a
hyperlink, not an icon. Exporting in Snapshot format allows the file to open
with same formatting as in the Access report, though it would open in the
snapshot application rather than within Excel.

You can export as an Excel document, though it loses any formatting you may
have on it. At that, you'd probably be best making a query and using Data >
Import External Data and performing an Access Database Query.

this is all to say it won't look like a chart embedded in Word, so you'll
need a workaround.