sharepoint 2010

Hi All, Every month I have this task of collecting data from about 200 reports, into a main central consolidation file. The Report is an Excel file stored on SharePoint. All the Data i need is on a hidden tab in one Range. Process:- 1. I go to the SharePoint site where the files are stored and...

Hello, Formula works in excel .. but not in sharepoint. Not sure i've posted in correct forum for sharepoint, i viewed similiar thread in this forum. Need to extract total business hours worked between 2 dates\time (Date and time format)...

Hello, I'm struggling with combining SP and Excel. I've got a document lib. on SP with metadata FileName/Checked Out To/Modified by in normal view. My macro is going to open one of these files stored on SP. What I need to do is to verify if file, which I'd like to open, is Checked Out and, if...

Hi Experts, I get below error msg sometime when i open my excel file which has vba code in it. Error msg: "We found a problem with some content in 'my excel file.xlsb'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, Click Yes." then i always click...

Hi Gurus, I have been facing a problem that I am unable to solve by myself. I am copying and pasting a few worksheets from a SharePoint site into a local file. Some of the worksheets are lists so I have to differentiate among them. Nonetheless Excel will not allow me to paste in the local...

i have excel document in sharepoint 2010 library. i need add excel properties that use values from sharepoint columns in excel cells. name of properties are in unicode text. on net i found next code Function docprop(Info_needed As String) As Variant Application.Volatile DocPropCustom =...

Hi, i have a list in sharepoint which acts as my datasource for the application am working on, i can get data feed (OData) in the browser but when i try to import the data in powerpivot model it fails with the below error message. Please help me fix it. ============================ Error...

Hi All, I am attempting to build a macro that will loop through all files in a given sharepoint folder that I have mapped to a drive, check if they are currently locked for editing by another user, if they are locked for editing it will skip over them, if they are not locked it will open, update...

Hi, I'm currently working on a Dashboard that is made available to the users through SharePoint 2010. I would like for the users to be able to change currency on the Dashboard so i have come up with a fairly simple solution where the users select currency from a Data Validation drop-down...

Hi Guys, I have created a Workbook which is due to be used by ~100 users. Each user will have their own copy of this Workbook, which contains a Userform which allows them to update/add/remove a selection of records (these records are just rows in a worksheet which sits behind the Userform)...

Is there an "in" array formula option or equivalent? So item in list: return item Anyway, for problem I need to check people names against a list of names derived from SharePoint entry and return the offset of them attending(possibly multiple events) and what event. So say this was the...

Can anyone recommend good basic user reference materials for creating business and personnel related dashboards in Excel 2013 and interfacing for display with SharePoint 2010?

So I'm trying to find a way to hyperlink a file on a sharepoint 2010 to my excel spreadsheet using VBA initiate by a CommandButton. Is this possible? I also want it to choose the file based on the value (name) in column 2 (B) and put the hyperlink in column 12 (L) of the same row. I've...

Hi all, I am attempting to build a survey form in SharePoint 2010 to receive feedback, the form will contain a combination of both drop down lists and free text areas. I then want all submitted feedback (every time someone fills out the form) to then feed in to an Excel 2010 workbook so I can...

Hey, how shall I make Two-Way Synchronization on SharePoint 2010 Lists with Excel 2010.

Is there a way for me to see the number of comments in a workbook by viewing the file properties only? I would like to have a column in the SharePoint library that shows the number of comments for the workbook. Thoughts? Thanks!

I am racking my brain on this problem, and I can’t help but think there must be a better solution. I am trying to create a formula that counts the number of facilities that have findings in each of the areas (There are 80+ areas) :confused::banghead::help: I am trying to put together an excel...

Hi There, Can some on help me to place a excel sheet in sharepoint with drop downs and accessing the sheet in webaccess webpart? These drop downs will show up values to display it in the chart. I have certain limitations in sharepoint excel services like data validation will not work bu ti...

I have been using PP since the original release of the beta and have created lots and lots of galleries for PP on our companies sharepoint site. One complaint that I often hear from my users and clients is that they are not able to copy results out of silverlight. I try to explain that they...

Hi, I'm using a web database with Access 2010 and Sharepoint. I would like to insert QR codes based on field data. The problem is that all the add-ins I have found so far either are ActiveX objects or use VBA, which don't work with Web Databases. Does anybody have an alternative? Thank you!