iWork is Apple's suite of productivity software for the mac as well as iOS. iWork includes "Pages" for word processing, "Keynote" for presentations, and "Numbers" for spreadsheets.

learn more… | top users | synonyms

0
votes
0answers
11 views

Numbers: How to merge multiple sheets of products into one sheet, automatically update on change of data

What i'm trying to achieve is a database for food products split into three categories:- Frozen, Ambient and Chilled. Each category is on a separate sheet which is the data and in each category it ...
3
votes
2answers
44 views

The SUM function in Numbers 3.6.1 on my Mac OS X10.10.5 isn't calculating correctly. Why?

You can see in the attached screenshot that I have used the SUM function to add the values in column E. There are several "1" values (you can see one in cell E126) but the SUM always comes out at ...
0
votes
1answer
66 views

How does one use different languages in Pages headers and footers?

[EDIT] I'm afraid this language feature is gone in Pages 5.* How does one use different languages in Pages headers and footers? I don't need spell checking but language switching (for headers and ...
0
votes
1answer
58 views

Number 3.6.1: Cell value needs to be invisible, if the adjacent checkbox is checked

I'm not sure if this is the right forum, but here goes: I would like to keep the cell value (E8), if the adjacent cell (D8) is false (checkbox is not checked), else insert zero or null. I just keep ...
0
votes
1answer
30 views

Repeating a formula for every row in Pages

I'm working on a simple formula in Pages where I have a table with 4 cells per row. Product Name, Purchase Price, Quantity and Total. I've created a simple formula that multiples Purchase Price ...
0
votes
0answers
53 views

“Database” report writer for Numbers?

I serve on the Board of a Baroque Orchestra and have begun helping them get organized. The management of the orchestra does not have extensive technical skills so I've endeavored to help provide them ...
3
votes
2answers
939 views

Why are Pages/Numbers/Keynote not free in the App Store on new iPhone 6s?

I got a new iPhone in the US, but am using it abroad (Israel) and with my old Apple ID. In the App Store I see the Apple Pages/Numbers/Keynote with a price tag on them (not free) when they should be ...
1
vote
1answer
148 views

iWork and iLife are not free after reinstall

I recently bought a Macbook Pro 13" Early-2015 from a guy who used it only once and then reinstalled it for selling (already upgraded to the latest El-Capitan). After I set up my Apple ID I couldn't ...
1
vote
1answer
18 views

Numbers Between Formula

IF(AND(B13≤74,B13≥75,B13>90),"0","3, 5") Hey guys im basically trying to generate a if statement that outputs either 0 if under 74 or under 3 between 75 - 89 and 5 for over 90. I have been trying ...
0
votes
0answers
22 views

How can I change the behavior of alt-return and return in Numbers 3.6?

According to https://discussions.apple.com/thread/2448952?start=0&tstart=0, there's a box at the bottom of the table inspector: There are at least two ways to make multiple lines in a cell. ...
1
vote
0answers
19 views

In Numbers.app, Is there any function to identify if another cell is a formula, or contains a specific function?

I have a cell in a row that is either a directly entered number, or a SUM() of some other cells. Is there any function I can use in a different cell to know if the value in the former cell was ...
1
vote
2answers
87 views

How to correctly uninstall an App Store application [duplicate]

Recently I installed Pages which I purchased with version of iWork '09. Unfortunately this operation downloaded and installed version Pages 5.5.3 which is not exactly an upgrade of Pages '09. ...
1
vote
1answer
24 views

Pages: line break appears before end of line

For some very strange reason, I cannot seem to fit the text on line 2 inside the empty space of the 1st line. I tried deleting the words and re-writing them, which didn't work. I tried changing font ...
0
votes
1answer
46 views

In Numbers, how can I sum only if adjacent cell is certain value? [duplicate]

In excel, as shown here, it is possible to find and sum only cells with have a specific value next to them. Is there a way to do a similar thing in numbers? Specifically, I have a very long table ...
0
votes
3answers
4k views

iWorks no longer free after fresh install of El Capitan

I just installed a fresh copy of El Capitan on my MacBook Pro Retina (2013 model), and iWorks are no longer free in the App Store, as has been the case in Yosemite. See the screenshot: What are the ...
0
votes
1answer
54 views

Get pages and iMovies free

I got macbook pro late 2013 and normally Pages and iMovies they are free for mac after 2013 but when I got to app store I can't get them for free. Any help here or how to get them free ?
3
votes
1answer
606 views

Where are iWork templates saved?

I'm using iWork (specifically Pages 5.5.3) and I can't find the templates I created for this anywhere on the HD. Library > Application Support > iWork > Pages > Templates > My Templates Only shows ...
0
votes
1answer
85 views

Link tables for auto new rows - Numbers

Is there a way I can "link" tables in Numbers so that when rows are added to the "master" table that the identical rows and containing data are added in a linked table? I know I can "link" cells using ...
0
votes
1answer
12 views

Apple software - Numbers [closed]

How do I identify and add(sum) only specific cells in a row - they are not continuous cells. Ex. I1, O1, U1 total sum and show in BG1
0
votes
1answer
167 views

How do I plot two data streams in Numbers as a graph?

I have two different streams of fractional values I want to visualize using Numbers for Mac. They both have one value per line and both look would look something like this (with different values ...
1
vote
1answer
161 views

Can Numbers create stacked column charts with two columns for each category?

I'm trying to create a column chart in Numbers where each column is also stacked. For example, consider the following data. Here we have numbers for the total sample and numbers for how that total ...
2
votes
1answer
150 views

How to change chart colors in Pages 5?

I cannot change the individual colors in my charts. Under "Chart Colors" there is only this list of 12 predefined color swatches called "fill sets". Most of them are ugly. Not being able to change ...
2
votes
2answers
121 views

Launch an older version of an application by default?

There are two sets of applications where I'm running into this issue: iWork, where I only have the new stuff installed because Software Update harasses you to install the new stuff if it detects you ...
0
votes
1answer
119 views

How can I create a live updating slideshow?

I have a need to create a short slideshow style presentation (doesn't have to be a slideshow particularly if something else is more appropriate) which updates it's contents on the fly. The content is ...
0
votes
0answers
70 views

Apple Numbers … SUM all rows below cell (But NOT the summary row) dynamically

I have the following formula: =SUM(B4:B12) The cell this is in is B3. It works fine with the formula above. The problem happens when I add a row after B12. Then I have to readjust formula. to ...
0
votes
1answer
319 views

Safe to Delete Keynote Cache under /Library/Container/com.apple.iWork.Keynote/Data/Library/Caches

While the question "is it safe to delete /Library/Caches" is commonly seen, OSX also has another path for storing caches (not sym link). Keynote has another cache stored at ...
0
votes
0answers
86 views

Sync Numbers templates between OS X Yosemite and iOS 8

I want to create a template spreadsheet in Numbers for OS X Yosemite and have this template appear in Numbers in iOS 8. I've followed the advice in this page and have created a template on my Mac. ...
1
vote
1answer
2k views

How do I get to my Keynote 6.5 themes folder?

I've created a theme using File > Save Theme and would now like to share it with others. Where in the world is it though? It's visible in the File > Change Theme area but I can't find the source ...
2
votes
0answers
43 views

Looking for a grandma-safe way to create two-fold greeting cards

My Mom (+ 70) longs for the day when her Windows Paint Shop program would walk her through creating a 2-fold 8 1/2 x 11 card. She could assemble the card one page at a time and not think about what ...
2
votes
1answer
53 views

Pages question on Apple yosemite

How can I get rid of the Right hand column (with Margin, layout info) on the Pages. I just want the page to show my letter when sending. I run Pages v5 on OS X Yosemite.
4
votes
1answer
9k views

New version of Keynote won't open old versions

When using a newer version of iWork software such as on Yosemite to open older documents and presentations, Pages reports "This document can’t be opened because it’s too old. To open it, save it with ...
0
votes
0answers
57 views

Different sections with different amounts of columns in iWorks Pages

So basically I want to make a document where different pages have a different amount of columns. For example, I want a page to have 2 (equal width) columns while the next page has one (fullwidth) ...
0
votes
0answers
166 views

Mac Pages: How to put creation date on a custom template?

Some Apple-created templates have the date come up when you create a document. On custom templates, however, it only shows the date you made that template, the date doesn't update to whenever you ...
0
votes
0answers
168 views

Numbers.app - How to add up items from multiple sheets and popup lists

Based on the "Personal Budget" template: I want to use the Personal Budget template and modify it to my needs — I want a total sheet that will add up information from 12 data sheets (for each month). ...
1
vote
1answer
29 views

How to mark some columns as ignored for calculations Numbers?

I'm creating a template on Numbers and I would like to know if there is a way for the formula to ignore, or skip over some cells or even entire columns. I need these columns for some calculations, but ...
2
votes
0answers
537 views

batch convert iWork 08 files to new version on Yosemite

TL;DR Short version: I have a bunch of files that were created with iWork 08. Is there a way, maybe using AppleScript or Automator, to convert them to the new format (Pages 5.5, Numbers 3.5) without ...
1
vote
1answer
232 views

Are older versions of iWorks available?

Can I download a version of iWorks from Apple that will work with 10.6.8 before I upgrade to 10.7 or above. I have a lot of Appleworks files I want to convert before I upgrade the system.
1
vote
2answers
1k views

Linking between tables in Numbers

I have a table in numbers, and I want a cell to equal the value of a cell in a different table. Following the advice of this Apple discussion, I tried =Units Sold::B2 , with Units Sold being the ...
0
votes
1answer
792 views

Two value-based axis for chart in Numbers 3.5

I am trying to achieve a chart in Numbers 3.5 where both axis scale linearly. Right now, my chart looks like this: Obviously, I want the x-axis to scale because the 100.000 bytes message is MUCH ...
1
vote
1answer
9k views

How to get iWork and iLife after upgrading to Yosemite from Mavericks?

I bought a mid-2014 MBP Retina (activated on 30/09/2014) from a friend and did a re-installation of Mavericks, then upgraded to Yosemite right after the re-installation (without associating the mac to ...
2
votes
2answers
4k views

Auto-Populate A Pop-Up Menu in Numbers 3.5

I'm trying to steer clear of Excel, despite my sister's nagging, and I've done pretty well to create a Quote and Invoice workbook in Numbers. The problem I am having is working out how to ...
1
vote
0answers
39 views

How to quit a file without modification & without changing its modification time?

Within my work I regularly open files with Pages, Numbers, Keynote… and even if I typed anything within these files I want to be absolutely sure I didn't modify them in any way. Moreover I want to be ...
1
vote
5answers
2k views

Paste HTML into Pages

I'm trying to copy stuff (including tables) from a web page and paste it into a Pages document, retaining html formatting (as much as possible). With Pages'09 this used to work using OpenOffice as ...
6
votes
1answer
702 views

How did the function “Save As…” change to “Duplicate”?

I recently noticed that within Pages ('09), Numbers ('09), Keynote ('09), the menu entry: File > Save As… had been replaced by a new one: File > Duplicate On the other hand I still use this ...
0
votes
1answer
3k views

How do I add media not in iPhoto to a Keynote presentation

I want to use folders other than IPHOTO and PHOTOBOOTH when adding media in iWork applications. For example when using Keynote, this pops up. How do I add folders to the pop-over meniu?
2
votes
1answer
611 views

Disabling warnings in iWork

Is there any way of disabling the warning popups in the current versions of Numbers, Pages and Keynote that popup when files are opened? For example: They are pretty useless warnings, in the sense ...
2
votes
1answer
2k views

Installing just Pages 09 from old iWork 09 Disk on Yosemite

I still love the old pages '09 I run it side-by side with the new pages on my two iMacs. However, on my new Macbook it is not installed and I want to run it on there (the new pages doesn't have some ...
3
votes
3answers
8k views

'Show Package Contents' in new iWork (Yosemite) File Formats

After installing both Yosemite and the new iWork suite updates (Pages 5.5 and Keynote 6.5), I've noticed I can't 'Show Package Contents' in order to access/modify the media associated with these ...
1
vote
1answer
17k views

Is iWork for free for Yosemite Users?

I just upgraded to OS X Yosemite and as far as I recall the presentation Apple said that iWork is for free now as well? The reason I ask is because there is still a price in the App Store. Or is just ...
3
votes
1answer
687 views

Keynote - How do I get rid of the default background images?

So. I'm using keynote to build slides for church music overheads. This means I need to build a different slide deck for each song we sing, so that we can change out the songs from week to week. ...