Pulling Info From 1 Numbers File Into Another

Hi...I want to pull information from a cell in one Numbers file into another cell in totally separate Numbers file. A couple of questions:

1) Is this possible;
2) If so, does the source file need to be open in order for the other file to gain the info; and
3) If this is doable, how do I do it?

Thanks so much.

Apple MacBook Pro, Mac OS X (10.6.3)

Posted on May 6, 2010 1:13 PM

Reply
6 replies

May 8, 2010 8:25 AM in response to KOENIG Yvan

Yvan, no doubt you are correct but it's the one thing I have really found disappointing in switching to the Mac.

In my company and most others who cater to the public we read everything, even pay a sub-contractor to help. Why? because we have been trying to make a living serving a need and get paid for it. Apparently the Apple people are not in the same position and have little understanding of what these forums are telling them .. especially people like yourself who apparently have adopted them (forums) as your main thing.

And, it is appreciated.

May 8, 2010 8:57 AM in response to Ed Law

I posted scripts passing datas from a Numbers document to an other one.

The drawback is that the transfer isn't automatic. It requires an user action.

At this time, links between two Pages documents are available.
Merge from Numbers to Pages is available.
Maybe we will get links between Numbers documents.

If you really want that, ask Apple for that :

_Go to "Provide Numbers Feedback" in the "Numbers" menu_, describe what you wish.
Then, cross your fingers, and wait _at least_ for iWork'11 😉

From my point of view, as I already wrote several times, what would be fine is the delivery of a function SCRIPT (or CALLSCRIPT) allowing a cell to trigger a script passing it parameters like the MACRO function available in AppleWorks spreadsheets.

The main problem is that at this time, each change introduced somewhere in a Numbers document forces a recalculation of the entire document so, the script would be triggered after every keystroke which would be unusable.
AppleWorks code is more intelligent which recalculate only cells targetted by a modification.

Yvan KOENIG (VALLAURIS, France) samedi 8 mai 2010 17:57:13

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Pulling Info From 1 Numbers File Into Another

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.