.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Formula showing in OSSR Excel spreadsheet exported from SharePoint list

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

I exported a list of SharePoint issues into an Excel workbook (2010).  The workbook seemed to work normally as I added new columns and  formulae until just now.  Now when I add a variance calc formula in a cell I see only the formula.  The formula is in a format like "=([@[Prior Est]]-[@[Actual (3/27)]])" instead of "=(G2-F2)" and nothing I do seems to get it to show the actual value.

Is there some sort of bug in the SharePoint excel exports after so many columns are added, or what?

View Complete Post

More Related Resource Links

Export SharePoint List to Excel Spreadsheet Programmatically using C#

In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

Import Excel spreadsheet To Sharepoint List

Hi, I am having sharepoint 2010 RTM trial on Windows Server 2008 SP2. I want to populate csv filke data to new sharepoint list. I am using custom List Wizard to achieve this... When I Import csv on server then everything is fine but when i inport csv from client, i get the following error "The Specified is not valid Spreadsheet or contains no data to import" I have also checked to import excel workbook but it gives the same error on client and do great on server..... can anybody have any idea what is wrong ?? thanks

Sharepoint 2010 List from Excel Spreadsheet to Display as Options in Infopath 2010


I have an Infopath 2010 form where I want the users to be able to display the cost of something based on the results of the data in an excel spreadsheet.

This spreadsheet does not have to stay a spreadsheet, I can import it into a List if that will make this work. So the spreadsheet has types of appraisals along the "X" axis and then individual States along the "Y" axis.

So if I am filling out the form - I want a "residential" appraisal and it is going to be in "California" - that should return the cost.

Any help woudl be appreciated. I am not sure exactly where to start.

Exporting SharePoint list to excel.

Hi All,   We have a SharePoint list in which one column is "Person or Group" and it can take multiple values. When we export it to spread sheet this column contains some junk data.We are using MOSS 2007 and Office 2007. Previously asked question on the same issue http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/00cc338d-8201-4b8d-b2ea-5979ee58a464 Does any one know of a Microsoft published article for this issue as we need to provide it to our higher ups for this issue.   Thanks.

scrollbar is not showing for sharepoint list with group by view

Hi, have created a Share point 2007 list having a huge data. I have created a group by view by grouping the data with category. My requirement is to show the data as web part on a page. When i did so, while expanding the group inside the web part, the web part is expanding. I want to keep the height and width of the web part fixed so that the layout of the page will not be ugly looking. But though I am putting the option for fixed height and width in the web part setting but I am not able to see the scroll bars. Where as I can see the height and width are fixed but could see a few data instead of all the data with scroll bar.   Please advice me if there is any solution or workaround.Deeptyranjan

Excel External Table Data can only create new SharePoint List when Exporting from Excel?

I have a SQL Query that I refresh everyday in Excel. I want to be able to export this list over to a SharePoint list right after my refresh in Excel but I can only Export to a SharePoint list only once. If I try to export again to the same list then it will give me the error "The specified list name is already in use on this server. You must rename the list before publishing it to the server." I have web parts that have connections to this list and I do not want to export my Query to a new SharePoint list everyday. Does anyone know a way around this issue?

Pulling data from an Excel Speadsheet to a Sharepoint List

I have an Excel Spreadsheet filled with company phone numbers which I would like to pull into a Sharepoint List. I am unsure of how to go about this, as my only experience so far is using SQL statements for an Access Database to pull information from one location to another. I would also like this list to be searchable and sortable if possible. As another option, I have looked at Datasheet views in Sharepoint and it is possible that the data could be re-entered in here (will take a very long time though) but I unfortunetly also don't know how to export the data into a printable document from here. Any help with either option would be very much appreciated as I am quite new to Sharepoint! Thank you very much

Sharepoint export to spreadsheet gives two extra columns in excel 2007 named as type and path, is th

When i export a list in excel 2007, it creates two extra columns named as type and path. At the same time this behaviour is not exhibited in office 2000. Is there any way to remove these two columns without using code ? Is there any configuration settings required for this, to remove it on the fly ? Thanks Ravish Verma

the list cannot be imported because a windows sharepoint service-compatible spreadsheet application

I have googled this for 3 days now, without any solution. I have install, reinstall services and ms office, save as web the excel file for import, without any results, have anyone encounter this error. I need help.

SharePoint 2010 Export list Items to Excel, wrong url in iqy file

Hi, I have a SharePoint 2010 Environment that uses https://portal.<something>.com. Exporting to Excel of a list uses wrong URL. When I go to the a list, select the list to show the "office ribbon" and then select export to excel, excel will show the error "Excel cannot connect to the SharePoint List". When I take a look at the IQY file that is created it contains the wrong url: http://portal.<something>.com instead of https://portal.<something>.com Changing the URL in the IQY file manualy to https://portal.<something>.com and then opening it will excel is working fine, list data is exported to excel then. Alternate access mapping is configured to use https://portal.<something>.com as default, export to access is working normaly. I already deleted the http://portal.<something>.com alternate access mapping once to see if this fixes the problem. No fix, even not after IISreset or rebooting the server. Where or how is the export to Excel IQY file created and where is it possible to fix the URL it is putting in the IQY file? Grtz, Arjan

List exported to Excel 2003

We are currently in the process of moving our Sharepoint 2007 server from one farm to another and the URL is going to change.  We have a lot of users who edit and update their data using Excel 2003 ( Using the Export to Spreadsheet option ).   Some of these spreadsheets have multiple tabs  and VBA code  for processing the data and generating reports.  There is no menu option that lets us edit the query to make the change to the URL. Is there any easy way to replace the URLs of these queries to point to the new URL? Vijay  

Not able to Import Spreadsheet into SharePoint list.


Hello All,

I am working on WSS 3.0  and with MS Office 2007. I want to import an excel spreadsheet into SharePoint list using the feature provided under "Custom List -> Import Spreadsheet". Whenever I try to Import SpreadSheet i got following error;

Cannot connect to server at this time. Your table cannot be published.

Simultaneously, I am not able to utilize Export to Spreadsheet functionality present under " Actions => Export to Spreadsheet". Whe i tried to export the list it gives "Cannot connect to sharepoint list" error.

Can anyone help me to fix this issues?
Thanks in advance. Waiting for your valuable response.



SharePoint 2010 Approval Workflow email is not showing link to Workflow Task list



I have created an out of box Approval workflow in SharePoint 2010. I am receiving email with below information

Task assigned by Chinna Malipedu on 10/7/2010.

Due by 1/1/0001

Approval started by Chinna Malipedu on 10/7/2010 11:43 AM
Comment: Approve



To complete this task:
1. Review SharePoint2010.
2. Perform the specific activities required for this task.
3. Use the Open this task button to mark the task as completed. (If you cannot update this task, you might not have access to it.)

But I need to go to Workflow Task List by clicking 3 item "Use the Open this Task" , this is not a link here

or I want like "Edit this task to mark the task as completed."  Edit this task should link to Task List

How to do this? do i missing any configuration?

I have successfully done the same  in MOSS 2007.                                                               Is there  any extra&n

Excel spreadsheet properties push to sharepoint library columns


Hope this is the right forum; if not, please direct me to the right one.

In Excel 2007 I am filling in a document property programmatically in an Excel 2003 spreadsheet, and creating/filling a custom one.  Just FYI, I use the following VBA code:

    ActiveWorkbook.BuiltinDocumentProperties("Company") = "TEST COMPANY NAME"
    ActiveWorkbook.CustomDocumentProperties.Add "Manager's Name", False, msoPropertyTypeString, "TEST MANAGER NAME"

Then I save the document to a SharePoint library.  Right now it is saved as a 2003 version spreadsheet (.xls).  There are a Company column and a Manager's Name column in the SharePoint library, and Microsoft's online documentation says the properties should populate the corresponding columns in the library.  But they don't!

That's my problem--getting them to populate.  Incidentally, thinking that the spreadsheet version was the problem, I have tried saving these documents both as 2003 spreadsheets and 2007 spreadsheets in my code, but the SharePoint columns never populate either way.  The only way I can do it is by manually filling in the document property from the UI.

Does anyone know what I'm doing wrong, either in Excel or SharePoint or somewhere in between, to cause this?  Is there a non-code solution to the problem?  I can do some C# code if I h

On excel sheet upload read the workbook and populate data to sharepoint list


Requirement in my current project:
In a document library when I upload an excel sheet, a specific workbook has to be read and the contents have to be uploaded to a sharepoint custom list.
The approach followed was create an event receiver and register as a feature. Following is the code for event receiver.

public override void ItemAdded(SPItemEventProperties properties)
            var list = getSPList("{150301BF-D0BD-452C-90D7-2D6CD082A247}");          
            SPListItem doc = properties.ListItem;
            doc["Msg"] = "items deleted from req list";
            string excelname=doc.File.Name;

Consume SharePoint List in Excel Services


I found some older questions regarding this but they are all listed in the Pre-SharePoint 2010 forums. I wanted to know if there is anything I can do to more easily pull data from a SharePoint List (more specifically a set of related lists) into Excel Services such that data refresh is handled as well.


I found a couple topics that used UDF as solutions to this problem, but I am not sure if they will handle data refresh. These solutions are discussed in: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/79f5c968-b68f-4d53-bfe0-d57258cfed6c and http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/16f9255d-cd06-4687-ab8e-68bd6210d0f8


I am hoping the 2010 version of Excel Services can handle this more simply, thanks!

SharePoint List Lookup Not Showing All Column's From List Identified

In SharePoint 2010 I"m using a lookup column and I have the option to "Add a column to show each of these additional fields:".  The problem is that these additional fields listed are not all the fields in the target list.  How do I get the field I need to show up on that list? 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend