Data Tables in Microsoft Excel 2008
Data Tables let you see how the results of a formula change as its underlying variables change. After entering data, select the entire table and choose Data > Table. Then tell Excel which row input cell and column input cells you want the table to use. Finally, click OK. Excel will crunch the numbers and present a new Data Table.
Visit Microsoft Mac Mojo blog
Submitted by
Microsoft MacBU
Recent TidBITS Talk Discussions
- Alternatives to MobileMe for syncing calendars between iPad/Mac (1 message)
- Free anti-virus for the Mac (20 messages)
- iTunes 10 syncing iPod Touch 4.1 (2 messages)
- Thoughts about Ping (16 messages)
Other articles in the series All About iPhoto
- iPhoto 5.0.3 Fixes Bugs (18 Jul 05)
- iPhoto 5: New Features Abound, Limitations Remain (09 May 05)
- iPhoto 4.0.3 Released (09 Aug 04)
- iPhoto 4.0.1 Fixes Bugs (29 Mar 04)
- iPhoto 4: The Potential Remains (23 Feb 04)
- Adam's iPhoto 2 Visual QuickStart Guide Available (19 May 03)
- iPhoto 2 Steps into the Frame (03 Feb 03)
- iPhoto Power Techniques (19 Aug 02)
- iPhoto Book Now Available (01 Jul 02)
- Do More with iPhoto 1.1.1 (13 May 02)
- iPhoto Joins the iFold (07 Jan 02)
Published in TidBITS 780.
Subscribe to our weekly email edition.
- Apple Intermediate Codec 1.0.1 Improves Performance
- Apple Spreads Some Green for Eminem
- DealBITS Drawing: Stock WatchTower Winners
- DealBITS Drawing for PublicVPN.com
- NetNewsWire Lite and Pro 2.0 Released
- Yahoo Swaggers Into The Music Subscription Fray
- Two Gigabytes or Bust
- Fontographer Spun to Fontlab
- Instructions from Outer Space: GPS Car Navigation
- Take Control News/16-May-05
- Hot Topics in TidBITS Talk/16-May-05
iPhoto 5.0.2 Freeze on Launch in Tiger
I recently upgraded to Tiger using the Erase and Install method that Joe Kissell recommends in Take Control of Upgrading to Tiger; I wanted the cleanest start with the new operating system. Most things went fine, except for launching iPhoto 5.0.2 afterwards; it always hung with the spinning pizza of death. I eventually solved the problem, but to give you an idea how I troubleshoot - along with the eventual solution - here's what I tried:
<http://www.takecontrolbooks.com/tiger- upgrading.html>
I rebuilt the iPhoto Library by holding down Command-Option at launch. Unfortunately, that didn't help. The goal here was to see if some sort of repairable corruption in my iPhoto Library folder was causing the problem.
I switched to another iPhoto Library by holding down Option at launch and choosing a different iPhoto Library folder. This didn't help, but eliminated the possibility of the problem being in my main iPhoto Library folder.
I created a new, empty iPhoto Library folder (again started by holding down Option at launch). The goal here was to see if there could be some problem related to an iPhoto Library folder that had been used in Panther.
I moved the com.apple.iphoto.plist file from the Preferences folder to the Desktop to see if corruption in that file might be the culprit.
I opened iPhoto's Info window, and in the Plug-ins section, I deleted all third-party plug-ins that I'd installed. Most were turned off anyway, but I wanted to make sure none of them could be the cause of the freezes.
With those five attempts under my belt, I figured the problem was most likely related to the iPhoto application itself (since I'd eliminated everything else I could think of). So I trashed the iPhoto application and reinstalled it from the iLife '05 DVD. On the next launch, I told iPhoto to create yet another empty iPhoto Library, and for the first time since installing Tiger, it continued to run. I then updated it to 5.0.2 using iPhoto's Check for Update feature and Software Update, and after that, I was able to load all my iPhoto Library folders.
Since the disk had just been reformatted, I didn't suspect any sort of directory corruption, but if reinstalling hadn't worked, I would have used Disk Utility to repair permissions and then, if that didn't work, to repair the disk itself.
Although I was annoyed at having to work through iPhoto's freezes, I knew that I had two current backups of my entire hard disk, so I wasn't particularly concerned about losing any data.
![](/file/11593/db.tidbits.com.tar/db.tidbits.com/images/badges/data-rescue-center.png)
hard drive recovery, data migration, and photo archiving options,
all at affordable and fair prices for individuals and businesses.
Get a FREE estimate today at <http://www.thedatarescuecenter.com/>