A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

how can I auto refresh pivot table with sheet protection

Thread Tools Display Modes
Old November 12th 08, 10:34 PM posted to microsoft.public.excel.misc
external usenet poster
Posts: 10
Default how can I auto refresh pivot table with sheet protection

i have one sheet, in that sheet i have the data and the pivot table.

the data will come from some scanner in determinate range of cells ( for
example: data:C5:E150), every time that the operator use the scanner to read
the bar code it will appear in that specific range in that sheet .

And I want that the pivot do the autorefresh, everytime, all that I
mentioned in the first paragraph I'm ok, and I can do that, but I don't want
that the operator by error use another cell that doesn't belong to the range
C5:E150 (Data), for that reason i want to protect the whole cells, except for
that specific range C5:E150 and also I want that this protection will allow
the autorefresh in the pivot table every time that the operator use the
scanner, actually if I activete the sheet protection the pivot doesn't auto
refresh and also it shows me an error

The reason to this is because I have another file that take information from
this pivot table, that other file show me the remaining of production and I
want to have the real information every time that i open the second file
(production remaining).

I hope this explanation can help, and please remember that you are talking
with somebody that don't know nothing about codes.

thanks and best regards

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
auto refresh pivot table [email protected] Excel Discussion (Misc queries) 0 October 15th 08 03:17 AM
Auto refresh pivot table Eleanor M Excel Discussion (Misc queries) 3 September 12th 06 08:54 PM
Sheet protection code conflicts with Pivot Table "auto refresh" KG Excel Discussion (Misc queries) 6 December 21st 05 11:16 PM
auto refresh of pivot table Luc Poppe Excel Discussion (Misc queries) 9 September 10th 05 06:02 PM
How do I get a web query to auto-refresh before a pivot table aut. Conniemm Excel Discussion (Misc queries) 0 December 8th 04 06:49 PM

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

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