Tell Bill Gates to fix Excel bug, urges 'Pivot King'
AccountingWEB's Excel Topic Expert David Carter has warned of a potentially lethal bug in Microsoft's Excel spreadsheet program and urged community members to tell Bill Gates to fix it.
"Now that the danger of the Y2K bug has passed, it's time to tackle the AZ bug," said Carter, the self-styled "Pivot King".
The problem occurs when users use Excel's AZ icon with a single column highlighted. Although data in that column will be sorted into alphabetical order, the other columns remain as they were - potentially corrupting the user's database.
"This is a Grade-A fault and quite lethal," said Carter. "One day you will need to do an AZ Sort and will click on the column heading without thinking. You won't realise what has happened until later, and if in the intervening time you have saved the workbook, your database is corrupted beyond repair.
"The long-standing flaw is highlighted in David Carter's latest AccountingWEB tutorial on auditing and financial reporting with pivot tables.
"If there was just one tutorial I would like an accountant to see in order to understand the sheer power of Excel and pivot tables, this would be it," he added.
The follow-up to last month's Sage Line 50 tutorial provides pivot-table ready accounting records (trial balance, debtors control summary, bank reconciliation, daybook analysis) and generates financial reports from them.
The AZ bug adds a bit of danger to the exercise. Carter advises users they can either train their subconscious minds always to click on a particular row, say Row 10, before clicking the AZ icon. Or they can send an email to Microsoft's chief software architect Bill Gates urging him to fix the glitch.
"If a thousand British accountants all complain politely about it to Mr Gates at the same time, maybe we'll get some action," said Carter.
Bill Gates can be reached at the email address firstname.lastname@example.org.
David Carter's pivot table tutorials are among the most popular items on AccountingWEB. They include demonstrations on how pivot tables can be used for budgeting, and sales analysis. Sage users can also download and try Carter's SagePivot data extraction program.
- CIS 17 1
- Would Director's dividends on non-voting C shares risk being classed as "earnings" for NIC purposes? 310 4
- Why Shoebuy Coupon Shopping Made Easy With These Expert Tips? 95 5
- Accountancy packages for FRS 102 128 4
- Penalties for non-filing of EC Sales List 115 2
- where has the honest passion to help gone..??? 1,071 21
- PAYE 46 1
- Any Scottish members out there? 9,662 352
- Lexis Nexis 3 Month Cancellation Notice 68 2
- Mutual trading organisation paying tax for the first time 74 3
- VAT on Pub Kitchen Franchise 91 2
- Sportman claiming for training kit 259 7
- Can anyone recommend a good document scanner? 500 10
- How to cancel a partnership registration for self assessment 91 2
- Complicated freehold purchase and CA 101 1
- Declined for business bank account 788 10
- UTR reallocated by HMRC 263 3
- Vat on Royalites 139 2
- Accounting for share for share 126 6
- About to buy a block of fees. Any advice? 1,416 6
- Raiders of the Lost Tax File 1,200
- Chartered Accountant in County Down N.Ireland 415
- IPP (International Pension Plan) income 318
- National Insurance 316
- FRS 102 and loans from a director 267
- valuation of intangible asset FRS10 and FRS20 263
- Unnecessary S9A Enquiries 241
- Cass 5 FCA Client Money Software recomendation 237
- Non Resident 231
- Franchise income and costs 214