Excel Co-authoring issues

jamesh291183

New Member
Joined
May 12, 2016
Messages
9
Hi,

I've set up a spreadsheet to be co-authored but some users are saying there are issues when other users freeze panes in the shared doc. Is there a way around this? (Aside from saying don't freeze panes).
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
are they all using the same excel versions ?
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
is it the 365 or the 2016 access thats causing the problem
 

jamesh291183

New Member
Joined
May 12, 2016
Messages
9

ADVERTISEMENT

is it the 365 or the 2016 access thats causing the problem

I'm unsure as it all works fine.

I guess my question is if 1 person freezes panes will it always affect everyone or should other users still be viewing the spreadsheet with all panes unfrozen?
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
as its collaboration on one file then i guess whatever the user sets will be reflected for the entire book, unless they have individual pages
 

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,710
My expectation is that all edits are shared through the O365 web experience, which should include the Freeze Panes, a viewing edit.
 

jamesh291183

New Member
Joined
May 12, 2016
Messages
9
My expectation is that all edits are shared through the O365 web experience, which should include the Freeze Panes, a viewing edit.

Great, thanks for all your help. So I just need to get the users to be thoughtful with things like Freezing panes/hiding columns etc.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,474
Messages
5,636,537
Members
416,923
Latest member
jarri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top