And a bit of detail on the new stuff in 2013:
Excel 2013 New Functions
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Reply to: Sharing excel documents
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "Sharing excel documents"
Collapse
-
2013 also has:
- Improved Multi-threading and Memory Contention
- FlashFill
- Power View
- PowerPivot Add-In
- Timeline Slicer
- Slicer with Excel Tables
- Ability to Save files in OneDrive
- Windows App
- Inquire Add-In
- Charting Enhancements
- Recommended Charts and Pivot Tables
- 50 new functions
Leave a comment:
-
2010 also has:
Multi-threading recalculation (MTR) for commonly used functions
Improved pivot tables
Pivot Table Slicers
More conditional formatting options
Additional image editing capabilities
In-cell charts called sparklines
Ability to preview before pasting
Office 2010 backstage feature for document-related tasks
Ability to customize the Ribbon
Many new Function, most highly specialized to improve accuracy
Leave a comment:
-
2010 has these functions, not found in 2007:
Leave a comment:
-
Originally posted by WTFH View PostIt will work for 2010 onwards BUT it's going to get messy. If a user uses functionality in 2013 that isn't in 2007 (colours/formats/advanced filters) then it will not work for a user on 2007.
Or, to put it another way: Run, Forrest, Run!
So remember you heard it here first folks
I'll now take bets on whether the support call that their excel spreadsheet is broken and they have lost the data will come in 2018 or they will manage to get into 2019...
I am contemplating sending them a link to this thread.....
Leave a comment:
-
Originally posted by original PM View PostOk so this is going to be tried (even after I told them about BB's response)
Anyway does anyone know if it works cross version - e.g. excel 2007 v excel 2010 v excel 2013?
It will work for 2010 onwards BUT it's going to get messy. If a user uses functionality in 2013 that isn't in 2007 (colours/formats/advanced filters) then it will not work for a user on 2007.
Or, to put it another way: Run, Forrest, Run!
Leave a comment:
-
Ok so this is going to be tried (even after I told them about BB's response)
Anyway does anyone know if it works cross version - e.g. excel 2007 v excel 2010 v excel 2013?
Leave a comment:
-
Originally posted by original PM View PostYeah I have just found that...
wonder how well it will work!
cheers
Leave a comment:
-
Sharing a workbook is the worst way to allow multiple sheet updates. It will corrupt, be locked out, have the same record overwritten multiple times, etc etc
What's the requirement that leads you think this is needed? Usually happens when a client thinks a spreadsheet is a viable alternative to a basic database - you could set up something simple in Access and have a much better result.
Leave a comment:
-
Originally posted by WTFH View PostAs well as most MS software.
Leave a comment:
-
Yeah I have just found that...
wonder how well it will work!
cheers
Leave a comment:
-
Bad memories.
Yes you can.
Go to Review, click on Share Workbook, first option on the Editing tab is “Allow changes by more than one user at the same time. This also allows workbook merging”
Works in Excel 2010 & 2013 (that’s all I have available to check right now)
Leave a comment:
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Leave a comment: