E
Ed from AZ
I created a macro-enabled (Excel 2007) workbook. On one page, we
import data from a pivot table in another workbook into columns A and
B. The macro could not read the text in those two columns - it only
saw the link formula ([ThisWorkbook.xls]Sheet1!A2). So I went over to
cols F and G and put in =T($A2) and =T($B2). That seemed to work.
A Before Close workbook-level macro activates one particular worksheet
and saves the workbook. That's it.
When I open the workbook, my =T formulas are in cols C and D! C2 has
= T(A2), while D2 has =T(#REF!).
I opened the workbook, re-entered the formulas, saved and closed -
didn't import data or run any macros - and then immediately reopened.
The formulas had again moved!! There's nothing in the Before Close
code to delete any information or columns.
Any clues as to why this behavior? (Or how to code the macro so I
don't need the formula? I'm using wks2.Cells(rw, 6).Text, and Text
won't see it.)
Ed
import data from a pivot table in another workbook into columns A and
B. The macro could not read the text in those two columns - it only
saw the link formula ([ThisWorkbook.xls]Sheet1!A2). So I went over to
cols F and G and put in =T($A2) and =T($B2). That seemed to work.
A Before Close workbook-level macro activates one particular worksheet
and saves the workbook. That's it.
When I open the workbook, my =T formulas are in cols C and D! C2 has
= T(A2), while D2 has =T(#REF!).
I opened the workbook, re-entered the formulas, saved and closed -
didn't import data or run any macros - and then immediately reopened.
The formulas had again moved!! There's nothing in the Before Close
code to delete any information or columns.
Any clues as to why this behavior? (Or how to code the macro so I
don't need the formula? I'm using wks2.Cells(rw, 6).Text, and Text
won't see it.)
Ed