Problem creating formulas when exporting QuickBooks files to Excel

  • Thread starter Thread starter edpoz
  • Start date Start date
E

edpoz

I am having a problem creating formulas in Excel files exportd from
QuickBooks. When I copy a formula and paste to different cells, the
resulting cells show the same value as the cell where the original formula
was created. It is like I am using absolute cell references, but there are
no $ signs in the formula. I can change the value in the copied cells to the
correct the value by pressing F2 (Edit) key, buit was hoping on finding a
better way to resolve this issue. Has anyone else experienced this problem?
 
edpoz said:
I am having a problem creating formulas in Excel files exportd from
QuickBooks. When I copy a formula and paste to different cells, the
resulting cells show the same value as the cell where the original formula
was created. It is like I am using absolute cell references, but there are
no $ signs in the formula. I can change the value in the copied cells to the
correct the value by pressing F2 (Edit) key, buit was hoping on finding a
better way to resolve this issue. Has anyone else experienced this problem?
Click to expand...

Right click, copy, paste then select paste special and then select
formula only.
 
Back
Top