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
Bookmarks