Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Publisher / General MS Publisher Questions / May 2008

Tip: Looking for answers? Try searching our database.

How do i update a linked Excel cell location that has changed?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul - 19 May 2008 16:08 GMT
I have and Excel table that I have copied and linked into Publisher.  I have
added a few rows in Excel.  Is there a way to adjust the linked table in
Publisher to add those new rows or do I have to copy and Past those in?
Mary Sauer - 19 May 2008 17:06 GMT
Did you actually link the Excel worksheet or did you copy/paste it?

If you want the data to update you need to insert the worksheet as an linked
object. Insert, Object, click from file, click link, browse to the file.  When
you want to change the data, double-click the worksheet, do the changes. In
Publisher, right-click the worksheet, click convert.

Each version of Publisher is a little different...

Signature

Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

>I have and Excel table that I have copied and linked into Publisher.  I have
> added a few rows in Excel.  Is there a way to adjust the linked table in
> Publisher to add those new rows or do I have to copy and Past those in?
Paul - 19 May 2008 18:44 GMT
The excel table is copy and pasted as a link.  The probel is I added a few
more rows of information.  When the table updates it adds thosw new rows but
pushes the table down so the bottom rows get cut off.  Is there a way to
reselect the rows I want with out having to re-copy and past the table in
again?

> Did you actually link the Excel worksheet or did you copy/paste it?
>
[quoted text clipped - 8 lines]
> > added a few rows in Excel.  Is there a way to adjust the linked table in
> > Publisher to add those new rows or do I have to copy and Past those in?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.