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.
- Cash in Hand 172 3
- Buy to let and capitak gain 193 5
- are receipts needed? 637 17
- SA302's anyone?? 621 18
- Charge for use of credit card - permitted 337 8
- High value residential property - SDLT 15% 148 1
- 2013/14 failure to submit end of year submission 358 12
- Busines software 179 5
- Goods Purchased for Rental 210 6
- Converting a barn for business use 190 2
- Sale of house with planning permission - tax free? 320 4
- Flat rate Vat Scheme & Vat on wholesale production of Cakes and other deserts 327 12
- HMRC overreaching its powers -again against a small surveying firm? 496 10
- Going to need a tax, insolvency and legal specialist I think 335 3
- Bookkeping software 739 7
- Clogged Losses 290 5
- Letting relief on property transferred to a spouse 285 9
- ideas for a bonus scheme for accountants 671 10
- New Built in oven - allowable as repair? 282 4
- Accounting for Bank Loyalty Rewards? 138 1
- Nil Rate Band Trust - index linked debt by way of charge over property 910
- International interest certificate 523
- NOVA 375
- Have we escaped Gift with Reservation of Benfit & Pre-owned asset charges? - Gift after benefit 336
- Management expenses for investment company 278
- Bonus Bonds 276
- Entertainer withholding tax in Australia 187
- Insolvency and whistle blowing 171
- EXACT ONLINE 169
- P11D benefit received by widow 167