Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sharing Excel files

Sharing Excel files

ResolvedVersion 2007

Wed 31 Mar 2010, 16:43 Delegate Dips said...

Dips has attended:
Excel Advanced course

Sharing Excel files

Hi, I'm having difficulty sharing excel files, I have shared them many times before, but at the moment when trying to share a file, I get the error message "this file is no longer shared" whilst other people are still working in it, I was wondering whether this is something to do with excel, or if it is a systems issue for my IT department?

Thanks in advance

Dips

Tue 6 Apr 2010, 14:23 Trainer Stephen said...

RE: Sharing Excel files

Hi Dips

Thanks for your question

If the file is being shared by other users then this does sound like a local IT issue. I suggest checking this with your IT people first and if this is not the issue we can explore other possibilities.

Regards

Stephen

Tue 13 Apr 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

Sharing Excel files

Sharing Excel files

RE: Sharing Excel files

Excel articles

Excel tip:

Convert Text into Number