T
tallen
Our office has three workbooks that are linked by vlookups.
Workbook A contains several worksheets with large lists of products and
prices.
Workbook B contains vlookups which pull only certain products from Workbook A.
Workbook C contains vlookups which pull specific information from Workbook B.
The workbooks update links automatically. We have to open "A" before "B" so
the links update.
I can no longer open Worksheet B by double clicking the sheet. When I do,
excel freezes and ends the program, all open sheets close up. From that
point, I open a blank excel sheet and from the recovery window I can open
Worksheet A and B.
I am the only person in the office having this problem. Everyone is using
the same version of excel - 2003.
Does anyone have any ideas? Please let me know if you need more info. . .
Thanks!
Workbook A contains several worksheets with large lists of products and
prices.
Workbook B contains vlookups which pull only certain products from Workbook A.
Workbook C contains vlookups which pull specific information from Workbook B.
The workbooks update links automatically. We have to open "A" before "B" so
the links update.
I can no longer open Worksheet B by double clicking the sheet. When I do,
excel freezes and ends the program, all open sheets close up. From that
point, I open a blank excel sheet and from the recovery window I can open
Worksheet A and B.
I am the only person in the office having this problem. Everyone is using
the same version of excel - 2003.
Does anyone have any ideas? Please let me know if you need more info. . .
Thanks!