Help in creating Excel Dashboard
 

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

Help in creating Excel Dashboard
 

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

"Webtechie" wrote:

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

Help in creating Excel Dashboard
 

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
on a Word document, you get an actual chart not an icon. Does that make it
clearer?

"Sean Timmons" wrote:

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

"Webtechie" wrote:

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

Help in creating Excel Dashboard
 

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" wrote:

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
on a Word document, you get an actual chart not an icon. Does that make it
clearer?

"Sean Timmons" wrote:

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

"Webtechie" wrote:

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

Help in creating Excel Dashboard
 

Thanks. I will come up with a workaround.

"Sean Timmons" wrote:

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" wrote:

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
on a Word document, you get an actual chart not an icon. Does that make it
clearer?

"Sean Timmons" wrote:

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

"Webtechie" wrote:

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