sharepoint 2007

  1. D

    Excel 2010 Data Labels options not saving

    I have setup excel pie charts whereby I only want the data label option “percentage” to be shown. If I save the workbook with these settings, close and then re-open the settings are retained. When I then upload this workbook to my SharePoint 2007 site and select open, open snapshot in excel...
  2. S

    Excel 2010 to SharePoint List (2007): Create New List Record

    Would anyone have a solution for creating a record in a SharePoint list using the value from an Excel cell as the SharePoint Title? My Excel sheet has 3 columns: ID, Name, Description. I would like the value in the ID cell to auto-populate the Name column in my SharePoint list.
  3. S

    Integration of Access, Excel and Sharepoint possible?

    Possible connection between excel, access, and sharepoint? (And other questions) <HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1><!-- / icon and title --><!-- message -->Hello all, I'm a new user whom just registered yesterday. I'm currently using Excel 2003, Access 2003 and...
  4. S

    Possible connection between excel, access, and sharepoint? (And other questions)

    Hello all, I'm a new user whom just registered yesterday. I'm currently using Excel 2003, Access 2003 and Sharepoint 2007. Overview of the current situation At this moment, i have all my data stored in Excel like a 'database'. This Excel file is available in a staff Intranet, deployed...
  5. K

    How to get properties from SharePoint Document Library with VBA

    Within SharePoint I have a document library with several custom columns added that holds PDF files. With in my excel workbook, I would like to present a list of those PDF's to the user so that he/she can select one from a drop down list. Then at the click of button I want the workbook to...
  6. A

    SharePoint/InfoPath

    Are there any eager, helpful SharePoint/InfoPath mavens out there? Failing that does anyone know a good, smart, active user group that could help me with these questions? I have a couple of questions about using InfoPath 2010 to populate a SharePoint 2007 form library: 1. When editing...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

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