如何在excel中保护表后刷新所有表

时间:2022-04-26 01:02:01

My excel file have 2 sheets with named "A" and "B"

我的excel文件有两张表,命名为A和B

Both sheets showed the data from 6 queries (6 connection name) with view of sql server

两张表都显示了从6个查询(6个连接名)到sql server视图的数据。

Ordinary when I want to update the data in excel file, I press "refresh all"

当我想要更新excel文件中的数据时,我按下"refresh all"

but when I protect sheet "refresh all" can't process

但当我保护表“刷新所有”时不能处理

How Do I refresh all sheets including those with protection.

我如何刷新所有的床单,包括那些有保护的。

2 个解决方案

#1


1  

check out this solution

看看这个解决方案

How to protect cells in Excel but allow these to be modified by VBA script

如何在Excel中保护单元格,但允许VBA脚本修改这些单元格

https://*.com/a/126032/6868389

https://*.com/a/126032/6868389

#2


0  

my code is work if time for "refresh all" is a short time

如果“刷新所有”的时间很短,那么我的代码就是工作

but for my case "refresh all" take time about 15 minutes

但是对我来说,“刷新所有”需要15分钟

and "protect sheet" process is begin to process before "refresh all" process has done

“保护表”过程在“刷新所有”过程完成之前开始处理

如何在excel中保护表后刷新所有表

#1


1  

check out this solution

看看这个解决方案

How to protect cells in Excel but allow these to be modified by VBA script

如何在Excel中保护单元格,但允许VBA脚本修改这些单元格

https://*.com/a/126032/6868389

https://*.com/a/126032/6868389

#2


0  

my code is work if time for "refresh all" is a short time

如果“刷新所有”的时间很短,那么我的代码就是工作

but for my case "refresh all" take time about 15 minutes

但是对我来说,“刷新所有”需要15分钟

and "protect sheet" process is begin to process before "refresh all" process has done

“保护表”过程在“刷新所有”过程完成之前开始处理

如何在excel中保护表后刷新所有表