Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 24th 05, 06:37 PM
B_4j
 
Posts: n/a
Default Why won't pasted values from a formula appear in a pivot table

I am trying to make a pivot table from an array of information that was the
result of formulas on another worksheet page. I used a macro to copy these
formulas on the other worksheet page, then paste their values in the array
that I need a pivot table from. The pivot table will not sum any of the
values in the array and it does not combine cells in one column that are
alike if their corresponding cells in the adjacent column are different.
Everything works if I retype the data instead of copying and pasting. This
is not an option becuase there are several thousand lines of data. Thanks in
advance for any help.

  #2   Report Post  
Old June 24th 05, 06:53 PM
Debra Dalgleish
 
Posts: n/a
Default

Did you try the suggestion I posted yesterday?

'=========================
Excel is seeing the numbers as text. There are some techniques here that
you can use to convert the text to numbers, so they can be summed in the
pivot table:

http://www.contextures.com/xlDataEntry03.html

'============================

B_4j wrote:
I am trying to make a pivot table from an array of information that was the
result of formulas on another worksheet page. I used a macro to copy these
formulas on the other worksheet page, then paste their values in the array
that I need a pivot table from. The pivot table will not sum any of the
values in the array and it does not combine cells in one column that are
alike if their corresponding cells in the adjacent column are different.
Everything works if I retype the data instead of copying and pasting. This
is not an option becuase there are several thousand lines of data. Thanks in
advance for any help.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FORMULA REQD FOR ADD ING DATES AND VALUES AND PART NUMBERS ANDY CALLAGHAN Excel Discussion (Misc queries) 1 March 6th 05 10:35 PM
Combobox - use values in excel formula Nico Excel Worksheet Functions 1 February 2nd 05 09:22 AM
Cell Values Formula BubbaJ Excel Worksheet Functions 1 January 30th 05 11:40 PM
Need formula to check values of data in several cells as criteria VCTECH Excel Worksheet Functions 0 November 19th 04 09:54 PM
manipulating formula values Ramy Excel Worksheet Functions 4 November 19th 04 04:54 PM


All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017