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 email@example.com.
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.
- IR35 deemed payment and dividends - practical considerations 97 1
- Annual tax investigation cover fee? 450 13
- Coding Notice 216 6
- UK company paying dividend to foreign shareholder 224 6
- New business - journal entries 389 22
- Is CGT roll over relief available for let property 217 3
- Payroll software 636 16
- Statutory accounts, current company address, or one that was correct at EOY? 251 5
- Are there Special Rules for Agencies? 388 10
- 100% Annual investment allowance on luxury cars 721 18
- B2B vat in the EU 177 4
- VAT on Hire Purchase 133 1
- Samadian effect on self employed student support workers 193 4
- Changes to class 2 NIC's 224 3
- Client RTI Shows payments not his 188 4
- LLP as member of LLP 132 1
- Why should I retain membership? 2,820 48
- Alerting clients versus walking away from clients 500 7
- Vat 301 7
- SA online - 4 hour limit 1,300 13
- Auto enrolment excuses 849
- Feedback on accounts production software for IFRS 717
- Add T&Cs to Sales Order in Sage 402
- Social investment tax relief 217
- Digita Hosted Software 210
- Call Centre Data Costs 198
- accounting for this transaction 181
- Buying goods in US and selling them to company in US 170
- Travel costs and contractors 165
- Problems with Sage 50 Payroll v21(2015) 160