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.
- Associated companies 72 1
- 2 year rule? Self employed. 136 12
- P11d error 373 8
- Rental Income 214 2
- Share restructure 296 11
- Purchase buy-to-let property personally or LTD? 464 8
- Paperless office question 113 4
- RTI "Reason for submission being late" 376 7
- Warning about Tax Insider (taxinsider.co.uk) 905 5
- Stock Valuation 123 1
- Employment allowance and service companies (outside IR35) 464 14
- How long is filing an FPS meant to take ? 1,888 30
- Corporation tax due and repayable 85 1
- IR35 and working for an EU company 166 2
- Newsletter 216 4
- Business Challenges 500 11
- Do you design it or pick what's out there? 415 10
- £2000 Employment Allowance 264 2
- Is an iPad a taxable benefit? 274 4
- dividends, shares, waivers 1,136 15
- Residential Property Purchase Above £750K 720
- Using Sage with Sofa Categories 491
- Does anyone have an unwanted ICAEW wooden plaque? 326
- One man Company and closing payroll scheme as none paid 322
- Goods shipped inter EU and VAT Reporting 260
- growth voucher supplier 230
- VAT on Gaming Machines 202
- Sage 200 and Access Dimensions reviews 195
- transferring simply accounting 2010 from xp to windows 7 164
- Papilio UK Equity Release Mortgages Ltd 162