Is it possible to share only one tab of a spreadsheet?

Nope, that's why I suggested that the OP look for himself, I also don't know which version of Numbers this is about.

It also exists in LibreOffice, OpenOffice and NeoOffice, in fact it seems to be a function of every spreadsheet, maybe except Numbers.

LibreOffice

Hi volsgc,

Following up on quinn's print to pdf idea, your drop down will look something like this (depending on the apps you have installed):

If you're doing a lot of this you can select the sheet you want to share and skip straight to the print dialog with this script, which you could install in an Automator Service and assign to a keyboard combination:

tell application "Numbers"

tell front document to print with print dialog

end tell

SG

Hi Csound1,

I don't know if either version of Numbers can do this but I would check.

My saying this is a little like "teaching my grandmother to suck eggs" (because you've been on the ASC much longer than I have and have helped a lot more people) but it wouldn't hurt for all of us to occasionally review the ASC Use Agreement, including clauses 2.3 and 2.5.

Here's 2.5: " Test your answer. When possible, make sure your Submission works on your own computer before you post it."

Does your suggestion work on your own computer in Numbers 3 or 2 (or indeed Excel 2011)?

SG

Hi SG,

SGIII wrote:

Hi Ian,

Very nice. Your INDEX MATCH "cheat sheet" belongs in the official documentation.

SG

Do you recall this from last January?

Re: Need to return a cell value in a row where a date was selected from a column

That is when you showed me the advantages of INDEX MATCH over LOOKUP.

Regards,

Ian.

Hi volsgc,

Adding to SG's excellent advice, after you duplicate the document, "fix" any values on the sheet you want to share.

On the sheet you want to share, select all cells in a table, Copy (command c) then Menu > Edit > Paste Formula Results. That will place values instead of formulas that may refer to the sheets that you will delete.

Repeat with each table. Then all values will be independent of any deleted sheets.

Regards,

Ian.

Edit: "Paste Formula Results" is for Numbers 3. In Numbers 2, it is "Paste Values". Ian.

I don't think Numbers is the right software for you if you need highly customizable security settings in a multiuser context. It sounds as if you may need something more "industrial grade," such as Filemaker.

SG

Hi Csound1,

In Excel you can copy a single sheet from a multi sheet workbook to a new workbook and share that

That is true about Excel. But isn't the question here about Numbers, not Excel? Have you looked for, and found, a similar feature in Numbers?

SG

maybe except Numbers

Yes, maybe, though I don't think the maybe applies to Numbers 3 (and maybe not to Numbers 2 either, though I have less experience with that). Hence the workarounds suggested above.

SG

Hi volsgc,

volsgc wrote:

Thank SGIII and Yellowbox. However, the reason I wanted to send only one tab is to get rid of the need to do work multiple times. I have several clients that I was hoping to share data with daily. Copying and pasting multiple times works but is not efficient. I have created formulas to extract only a certain clients information in one tab. I would like to share that with each client without revealing information about the rest of the clients in the other tabs.

So your suggestion is basically saying I can share only one tab if I share a spreadsheet without any other tabs. I would like to share one tab in a spreadsheet that has multiple tabs. Does anyone out there have a solution for that?

In Numbers you can copy a sheet and paste it into a new document. However, any formulas will not link back to the original document. You must "fix" the values. Copy a table, then

(Numbers 2) Paste Values.

(Numbers 3) Paste Formula Results.

Another way is to copy a table and paste it into a word processing document.

No matter what spreadsheet app, there is no way around this. Either "fix" the values, or send the source data.

Regards,

Ian.

Hi volsgc,

If you need your clients to interact with your tables I think copy and pste is the only way to go.

You could print to PDF and share only the one tab. You would not be exporting a PDF from the Menu- that would share the entire spreadsheet. With the tab showing you want to share, go to print, hit print, then instead of sending it to the printer save it as a PDF. This has the advantage of saving a snapshot of what they actually got sent while the table will continue to be updated in your sheet.

quinn

SGIII wrote:

maybe except Numbers

Yes, maybe, though I don't think the maybe applies to Numbers 3 (and maybe not to Numbers 2 either, though I have less experience with that). Hence the workarounds suggested above.

Another good reason to avoid that rather mediocre spreadsheet then. There are superior alternatives that don't cost anything at all.

Hi volsgc,

The charm of numbers is in its ability to allow small, discrete tables, each with a purpose. Tables can be linked by formulas within or between sheets ('tabs') but not between documents.

If you are aiming to create a sheet for each client, I would call that a 'presentation' or 'report'. it can have a table that pulls relevant data from a large database. Further data processing can occur in that table or another table in the presentation. From there, you can create summaries and charts (graphs) for that client.

However, you must 'fix' all data that depend upon formulas that refer to the database. That is true in any spreadsheet app. 'Fixing' can be done by copying and then pasting the values, or (quinn's suggestion) by printing to a PDF.

It is over two years since I used Excel, so it may have changed since then. But I recall many Excel workbooks from colleagues that had lost the links to the source data. A message such as "Do you want to update from linked documents?" was useless. How could I update from Documents that were not included?

Are you creating presentations, or do you want your clients to have interactive spreadsheets? Interactive spreadsheets must include 'live' data and links, which means other clients' data must be removed from the database for privacy. More editing!

A clearer explanation of your aim will lead to a solution.

Regards,

Ian.

Hi Ian,

I recall many Excel workbooks from colleagues that had lost the links to the source data.

Yes, the loss of links is still true in Excel. It can't update "live" from the source data if the workbook with the source data isn't where it expects it to be, though it does allow the graceful opening of the workbook with the latest available data.

I'm not sure that either Numbers or Excel (not to mention their many competitors) are ideal solutions for secure and convenient and frequent sharing to many different people of just one "tab" at a time (here tab I assume means sheet with a table or tables of data for just one client).

But, with answers to the questions that you pose (in particular, what's the specific use case?), surely there are workarounds that can be useful in many situations.

SG