It’s 3:12 PM. You’re sitting in a conference room at Alibaba’s Shenzhen office, tablet in hand, waiting for the vendor presentation to start. The sales lead just slid a USB drive across the table — ‘All pricing sheets are in Excel.’ You plug it into your iPad via adapter… and stare at a blank Files app icon. No preview. No ‘Open With’ option. Your pulse ticks up.
The Setup
You’ve got 8 vendor quotes, each saved as a separate .xlsx file in a folder named Vendor_Pricing_Q2_2024. They’re inconsistent: some use merged headers, others have blank rows, and two include formulas referencing external workbooks (which don’t exist on the iPad). Here’s what the first file — Acme_Corp_Pricing.xlsx — looks like when opened on a Mac before transfer:
| Item ID | Product Name | Unit Price (USD) | MOQ | Lead Time (days) |
|---|---|---|---|---|
| ACM-7821 | Wireless Charging Pad Pro | $42.99 | 500 | 14 |
| ACM-7822 | USB-C Fast Wall Adapter (65W) | $31.50 | 1000 | 21 |
| ACM-7823 | Aluminum Laptop Stand (15") | $29.75 | 300 | 10 |
| ACM-7824 | Silicone Keyboard Cover (MacBook Air) | $18.20 | 2000 | 7 |
| ACM-7825 | Thunderbolt Docking Station | $129.00 | 250 | 30 |
| ACM-7826 | Eco-Friendly Mouse (Recycled Plastic) | $24.99 | 1500 | 12 |
| ACM-7827 | Wireless Earbuds w/ Case | $89.99 | 750 | 18 |
| ACM-7828 | Foldable Bluetooth Keyboard | $54.50 | 600 | 16 |
This sheet lives in cell range A1:E9. Note the clean structure — no merged cells, no hidden columns, no macros. That’s rare. And that’s why most people hit a wall.
The Challenge
Can iPad read Excel files? Technically yes — but only if they meet three silent criteria: (1) no external links, (2) no unsupported features (like dynamic arrays or LAMBDA), and (3) stored in iCloud Drive or Files app before opening. If you copy a file directly from USB to Files using the ‘Browse’ tab instead of ‘Locations’, iOS treats it as ‘unverified’ and blocks preview. The real kicker? Even if it opens, formulas referencing other files break silently — no warning, no error. You’ll see #REF! in B12:C15, but only after tapping Edit and scrolling down. What makes this elegant is that the fix isn’t about apps — it’s about where and how the file lands on the device.
Walking Through It
Here’s how we get Acme’s sheet fully readable and editable on iPad — step by step, with what changes at each stage.
Step 1: Move, don’t copy
Plug in your USB drive. In Files app, tap Locations → USB Drive → Vendor_Pricing_Q2_2024. Tap-and-hold Acme_Corp_Pricing.xlsx, then choose Copy. Now navigate to iCloud Drive → Shared → Procurement_Team. Tap Paste. Do not paste into ‘On My iPad’. Why? Because iCloud-synced files trigger full Excel engine initialization. Files in ‘On My iPad’ open in Quick Look mode only — no editing.
Step 2: Open with Excel, not Files
Tap the pasted file. If Excel isn’t your default, long-press the icon → Share → Open in Excel. This bypasses iOS’s generic viewer. You’ll see the grid load instantly — no spinning wheel. Bonus: keyboard shortcut Alt+H+V+V toggles between View and Page Layout (works even on Smart Keyboard).
Step 3: Validate formulas manually
Go to cell F2. It contains =IF(E2>15,"High Lead","Standard"). Works fine. But scroll to B12: =SUM('Vendor_Quote_[B2]!C2:C10'). That bracketed reference? It’s broken. Delete it. Replace with static values or rebuild logic using local data only.
| Before (B12) | After (B12) | Change Type |
|---|---|---|
=SUM('Vendor_Quote_[B2]!C2:C10') |
=SUM(C2:C9) |
Reference simplified |
=VLOOKUP(A2,'[Supplier_Master.xlsx]Sheet1'!A:D,4,0) |
=XLOOKUP(A2,$A$12:$A$50,$D$12:$D$50,"N/A") |
External ref replaced with local XLOOKUP |
The Result
After those three steps, here’s the final version — fully editable, formulas recalculating live, and ready to annotate during the meeting:
| Item ID | Product Name | Unit Price (USD) | MOQ | Lead Time (days) | Status |
|---|---|---|---|---|---|
| ACM-7821 | Wireless Charging Pad Pro | $42.99 | 500 | 14 | Standard |
| ACM-7822 | USB-C Fast Wall Adapter (65W) | $31.50 | 1000 | 21 | High Lead |
| ACM-7823 | Aluminum Laptop Stand (15") | $29.75 | 300 | 10 | Standard |
| ACM-7824 | Silicone Keyboard Cover (MacBook Air) | $18.20 | 2000 | 7 | Standard |
| ACM-7825 | Thunderbolt Docking Station | $129.00 | 250 | 30 | High Lead |
| ACM-7826 | Eco-Friendly Mouse (Recycled Plastic) | $24.99 | 1500 | 12 | Standard |
| ACM-7827 | Wireless Earbuds w/ Case | $89.99 | 750 | 18 | High Lead |
| ACM-7828 | Foldable Bluetooth Keyboard | $54.50 | 600 | 16 | High Lead |
Note column F — added with =IF(E2>15,"High Lead","Standard") in F2, then filled down with two-finger double-tap on cell border (iPad’s version of double-click fill handle).
What Could Go Wrong
Three specific failures we see weekly in procurement teams:
- Mistake #1: Opening from ‘On My iPad’ — You’ll see a grayed-out Excel icon and ‘Preview Only’. Tapping it launches Quick Look. No editing. No formula bar. No undo stack. Fix: Move to iCloud Drive first.
- Mistake #2: Using ‘Save As’ instead of ‘Export’ — When you tap Share → Save As, iPad saves a PDF. Not an Excel file. You lose all formulas and structure. Always use Share → Export → Excel Workbook (.xlsx).
- Mistake #3: Assuming AutoSave = Sync — Even with AutoSave on, changes made offline won’t sync until you reconnect to Wi-Fi and tap the cloud icon in top-right. We’ve seen users present outdated versions because they didn’t check that tiny blue dot next to the filename.
Here’s what to do next — no fluff, just action:
| Action | Where to Find It | Time Saved |
|---|---|---|
| Move file to iCloud Drive | Files app → Locations → [Your USB] → Copy → iCloud Drive → Paste | ~22 seconds |
| Open with Excel (not Files) | Long-press file → Share → Open in Excel | ~3 seconds |
| Check for external refs | Formulas tab → Name Manager → Look for ‘#REF!’ or external paths | ~17 seconds |
| Fill formulas down | Two-finger double-tap bottom-right corner of cell | ~1 second |
