?
Solved

How do I export a file and send it with linked data?

Posted on 2011-03-03
3
Medium Priority
?
192 Views
Last Modified: 2012-05-11
I have a book with two many sheets linked with external and internal sheets.

I want to export one sheet and send it out to another person, but I want him to see the data even if it was linked in the origin work book.

nabil
0
Comment
Question by:nabilhammoud
3 Comments
 
LVL 9

Accepted Solution

by:
McOz earned 250 total points
ID: 35027433
0
 
LVL 6

Assisted Solution

by:Eric Zwiekhorst
Eric Zwiekhorst earned 250 total points
ID: 35035502
Hi Nabil,

You can send the excel with the links IF the receiver has access to the linked documents and on the same way as you had when linking them.

I mean if you have a mapped networkdrive on F and the receiver has the same network drive mapped to H the links won't work..

If the network drive is accessable thru a url directly to this drive without it being mapped it wil work for other also.

When the linked files are on your personal drive they can't be viewed by the receiver and he will see only old values..


Kind regards

Eric
0
 

Author Closing Comment

by:nabilhammoud
ID: 35066295
THX
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question