How can I make another version without all the data

B

bankman

Hello all,

I have build a report in excel. The workbook (nr. 1) contains multiple
tabs which get their data from a txt-file. One of these tabs gets its
data from another workbook (nr. 2), which is stored in the same folder
/ map. When I open the first workbook (nr. 1) it doesn't show data
which is stored in the other workbook (nr. 2), but when I open both
files at the same time the problem is solved. But now comes the real
problem. One of the tabs of workbook nr. 1 is saved as a pdf-file. This
tabs contains graph's and a summary of the data in the other tabs. Is
there a possibility to save only this tab (sheet) without the other
tabs and still show the right data in the graphs ans the summary?
Something like a purge-function?

Thanks in advance for replying and thinking with me.
Patrick
 
Top