ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Constants in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/196107-constants-excel.html)

Sharon

Constants in Excel
 
Hi, I am using MOSS and Office 2007. I am collecting data via the SharePoint
list and then exporting the list to Excell on my desktop to manipulate and
aggregate the data. I have removed the table and broken the link with the
SharePoint connection, unlocked the cells. When I attempt to add formulas to
the excel spreadsheet, the formulas will work - when I evaluate the formula I
get "The cell currently being evaluated contains a constant". I have found
the cells that contain constants but need to remove the constants and can't
figure out how to do that. Can you help? This is very urgent for my business.



All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com