Re: [MS_AccessPros] Display Excel sheet on Access form

 

hi,

agree with Duane that a better way to go is linking to the sheet, which can be refreshed to update, and then making the chart(s) with Access.� Here is a video to show you how to do that:

How To Make a Graph with Microsoft Access (cc). 7-minute video.
http://www.youtube.com/watch?v=YhgNX6BWWmk&list=PLis0tV85b5t6TuFPTldPF-Ra67As6-Rj0

Bill said, "You can embed an excel sheet using an OLE control that is linked to the spreadsheet. It�s not the usual way to display a spreadsheet. You might want to just put a button with an event to follow a hyperlink to the sheet on the form to open the spreadsheet outside of Access."

That is also another option -- but making your own chart in Access using data you are linked to would be my choice.�

~~~
> "automatically update when excel sheet is update?"

Access cannot know when the sheet changes in Excel -- it could look at the file date/time and compare it to see if it needs to be updated though.� A good way to trigger this is to add a "Refresh" button that the user can click on to update. Alternately, you could use a timer event that automatically updates, but I try to avoid using forms with timers.

have an awesome day,
crystal

On 3/9/18 12:29 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] wrote:

I've never heard of this being requested or�done (I've read through postings in lots of forums for 20+ years)�but that doesn't mean it couldn't.�

As an alternative, you can link to an Excel worksheet and then display a datasheet view of the worksheet on an Access form. You can also duplicate some Excel charts in Access.

Regards,

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of milevicm@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, March 8, 2018 2:43 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Display Excel sheet on Access form

�

I need to display Excel sheet with one table and one chart on Access form. Is it possible to have preview of excel sheet on access form which will automatically update when excel sheet is update?

__._,_.___

---

Posted by: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___