Solved

Open Excel from Sharepoint

Posted on 2011-09-13
5
275 Views
Last Modified: 2012-05-12
I have opened excel spreadsheet worked on it and closed it. today I tried to open it and it gave me a message that it is going to open as Read only document even when I select Edit.
Though in the Sharepoint column[Modified], I can see my name there.

Any idea on how to fix this, and be able to open the document as "Edit" and not read only?

Thanks
0
Comment
Question by:jskfan
  • 3
  • 2
5 Comments
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 500 total points
Comment Utility
jskfan,

You  might need to check if other user is opening the file.

Ed
0
 

Author Comment

by:jskfan
Comment Utility
<<You  might need to check if other user is opening the file.>>
where to check that ??

0
 
LVL 19

Assisted Solution

by:MINDSUPERB
MINDSUPERB earned 500 total points
Comment Utility
Try to check out the Excel file by following the steps below:

1.Locate the document that you want to check out.
2.Point to the document, click the arrow, and then click Check Out.

If you can't see Check Out option, then other user checked it out.

Ed
0
 

Author Comment

by:jskfan
Comment Utility
I figured it out....
I opened the document in read only, then it showed an edit button above the spreadsheet , when I clicked on it, it showed the user who has the document opened.
I called the user he closed the document and I managed to open it in edit mode.
0
 

Author Closing Comment

by:jskfan
Comment Utility
thanks
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now