View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
edpoz edpoz is offline
external usenet poster
 
Posts: 1
Default Problem creating formulas when exporting QuickBooks files to Excel

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?