Help in creating Excel Dashboard

W

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
 
S

Sean Timmons

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

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
 
S

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.
 
W

Webtechie

Thanks. I will come up with a workaround.

Sean Timmons said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top