| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trend Line constants as Excel Cell Values | Excel Discussion (Misc queries) | |||
| Physical Constants for Excel | Excel Worksheet Functions | |||
| Wher can I download a table of Physical Constants for Excel? | Excel Discussion (Misc queries) | |||
| Excel sees cell formulas as constants, will not solve | Excel Worksheet Functions | |||
| vba constants for excel | Excel Discussion (Misc queries) | |||
Linear Mode
