Something strange is happening when I cut and paste tables or financial statements from web pages. The data or formula in the cell is showing up in the formula bar but is being ignored by excel formulas. Example 1. 1 Cut and paste financial stements into ecel from web page. Then try and access this data from another sheet. I use the copy down function to copy the cells from the sheet I posted the web data to. What happens is the cell value of the first cell is copied into all the cells BUT the formula in the formula bar references the correct cell so if I copied down the column according to the formula bar the formula in the cells is changing correctly as I go down, e.g othersheet!A1 the one below OthersheetA2 but the value in the cell stays as the value of the firsdt cell entered manually. If I then say for othersheet!A14 delete Just the 4 using the formula bar and replace it with a manuall entered 4 via the formla bar it now gives the correct value for A14 in the original sheet (othersheet). Example 2. I cut and paste a table into Excel and then try to perform a calculation in a cell referencing the table data â I get the error message #VALUE! . If I then type over the pasted value in the cell it calculates properly. Is there some long forgotten option that I have forgotten to check or uncheck? Tried a fe like âignore other applicationsâ and âtransition formula evaluationâ both of which I have vague memories of causing me some kind of problem many years ago. Any suggestions as to other forums to post this (e.g. specialised Excel forumds) welcome.