Pivot Table Opening Error

  • Thread starter Thread starter Karlos
  • Start date Start date
K

Karlos

Hi,

we have an access table with over 200,000 records

we wanted to use this in a pivot table. When we brought
the table across, it seemed to work (although it was a
11mb file) but as soon as it was closed and re-opened, the
file said "could not read file" and will not open.

Any ideas why

My feeling is that there is too much information for excel
to handle and its buckling under the weight.

any thoughts would be appreciated
 
Hate to state the obvious but was it saved with the
imported data as a xls file?...only asking this from
personal experience after using imported data files.
after importing and before doing anything with data I
always now save as ....xls then am able to play with the
file!!
 
Back
Top