• 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!

Sharing excel documents

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    #11
    Originally posted by original PM View Post
    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?

    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!
    …Maybe we ain’t that young anymore

    Comment


      #12
      Originally posted by WTFH View Post
      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!
      Yeah - I keep telling the business that this is generally seen by the technical community as a BAD IDEA and there is a good chance the spreadsheet will corrupt and they will lose everything.

      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.....

      Comment


        #14
        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
        …Maybe we ain’t that young anymore

        Comment


          #15
          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
          …Maybe we ain’t that young anymore

          Comment


            #16
            And a bit of detail on the new stuff in 2013:
            Excel 2013 New Functions
            …Maybe we ain’t that young anymore

            Comment

            Working...
            X