+ Reply to Thread
Results 1 to 1 of 1

Excel vs Sharepoint office365

  1. #1
    Registered User
    Join Date
    09-01-2020
    Location
    Bruges, Belgium
    MS-Off Ver
    Office 2019
    Posts
    4

    Excel vs Sharepoint office365

    goodmorning

    i have a few problems when i upload an excel with tables and slicers onto office 365.
    i realize an uploaded excel has a different lay-out and has some restrictions compared to offline, but these things are really annoying and i wonder if there is some kind of solution.

    1 : we are in europe, so the '.' on the numpad is being replaced with ',' reason is probably the regional settings are from US, but there are no options available when the file is uploaded.
    2 : press ENTER to select the cell to the right, offline there is an option to make the cursor go any direction when ENTER is pressed, but once uploaded it always goes down, there is no option to change that online?
    3 : there are 2 tabs that are mainly used, 'STOCK' and 'BESTELLING', offline it's all good, but uploaded strange stuff happens, when you select a cell let's say in the tab 'bestelling', one of the last cells with data in it (row 3923),
    then go to the 'Stock' tab and select something while using a slicer, then go back to the Bestelling TAB and the cursor will be on row 7000+, why is that?
    there are multiple people working in this excel online, but none of them has there cursor on row 7000+, why would the excel constantly go to a row that nobody is using/selecting?
    Same thing when slicers are being used, it hides rows, but removing the filter make the selected cell stay on for example row 35 while you had row 3512 selected....

    Added note : offline i can enter a formula in a cell like "=5*B3" or i can do "+5*B3'
    online there is only the possibility =5*B3


    any idea's/solutions?

    many thanks for your time

    kind regards
    Anthony
    Attached Files Attached Files
    Last edited by Anvdd; 10-09-2020 at 04:46 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] What function can be combined with IFNA in Excel Office365 / 2016
    By jpl69 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 02-25-2018, 09:18 AM
  2. [SOLVED] What alternatives to the IFERROR function are available in Excel 2016/Office365?
    By jpl69 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-24-2018, 10:30 AM
  3. Replies: 1
    Last Post: 02-24-2018, 10:11 AM
  4. [SOLVED] How to link office365 live sharepoint list with Excel?
    By ImranBhatti in forum Office 365
    Replies: 2
    Last Post: 06-11-2017, 01:59 AM
  5. VBA to select SharePoint Content Type when saving Excel file to SharePoint
    By Luffk73 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2017, 05:22 PM
  6. Replies: 1
    Last Post: 12-23-2016, 03:52 PM
  7. Replies: 0
    Last Post: 10-08-2013, 10:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1