I need help copying formula between tabs in excel

Copper Contributor

I have copied Columns from Webpge and pasting it on excel worksheet.

These columns contains text and Numbers.

The template was made which performs calculation of this Values and give output as Invoice.

This template was working fine with my older PC which has office 2013 installed.

I recently purchased Acerspin and it was loaded with Office 2016, bu when I am copying columns from webpage the automatic calculations are not happening and its giving #Value error.'

I tried loading office 2013 in New Laptop but it is again showing error of #Value.

Can you help me with this.

1 Reply
It would help if you posted an example.

The data could be being pasted as text. You might want to try formatting it as number, then use Data > Text to Columns > Finish to coerce the format to be applied.

Alternatively, try Data > Get & Transform > From Web, and import the data with Power Query. if you choose the Transform option, you can change the data type in the Power Query Editor.