ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Losing Query in Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/120274-losing-query-excel-2003-a.html)

Steemer

Losing Query in Excel 2003
 
Hi there,

I can find lots of people who have experienced this but no answers to
the problem.

I've set up a query in Excel 2003 to read an Access table - just like
I've done a million times before. When I do something else in the
spreadsheet, the query is no longer updateable or editable for that
matter. Its a pain and I'm hoping someone can assist. Thanks.

Steve.


Steemer

Losing Query in Excel 2003
 
Anyone??? I can't find any answers to this problem. Before I start
committing to changing versions I'd like to see if anyone here can
help. Thanks


Steemer wrote:
Hi there,

I can find lots of people who have experienced this but no answers to
the problem.

I've set up a query in Excel 2003 to read an Access table - just like
I've done a million times before. When I do something else in the
spreadsheet, the query is no longer updateable or editable for that
matter. Its a pain and I'm hoping someone can assist. Thanks.

Steve.



Steemer

Losing Query in Excel 2003
 
I stopped hiding columns in my data table and it seems stable for the
time being. Don't know if that's what the problem was - I didn't make
any other changes or adjustments - did a hell of alot of reading
though.




"Help yourself... no one else will."
~Art Caldwell


Steemer wrote:
Anyone??? I can't find any answers to this problem. Before I start
committing to changing versions I'd like to see if anyone here can
help. Thanks


Steemer wrote:
Hi there,

I can find lots of people who have experienced this but no answers to
the problem.

I've set up a query in Excel 2003 to read an Access table - just like
I've done a million times before. When I do something else in the
spreadsheet, the query is no longer updateable or editable for that
matter. Its a pain and I'm hoping someone can assist. Thanks.

Steve.




All times are GMT +1. The time now is 03:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com