excel存檔就當機

 環境:

2007，2010，2013，2016，m365 excel 

異常狀況:

同一個xlsx檔:

透過m365 excel 開啟後，存檔正常。

透過2007，2010，2013，2016 excel 開啟後正常，存檔的話excel程式就會當掉。

解決過程:

該檔案中，有附上幾個貼圖。

在m365 excel裡可正常看見圖，但在2007，2010，2013，2016 excel 中，看不到圖，只會看到#VALUE!

因為該圖是用m365裡的「圖片置於儲存格內」功能放入，這功能只有在 Microsoft 365  Office 2024，但在其他較舊的excel則不支援。

所以不但看不到圖，就算只是在其他欄位修改資料存檔，都會直接當掉。

Environment

• Microsoft Excel 2007

• Microsoft Excel 2010

• Microsoft Excel 2013

• Microsoft Excel 2016

• Microsoft 365 Excel

Issue

Opening the same .xlsx file shows different behavior depending on the Excel version.

• Microsoft 365 Excel: Opens and saves normally.

• Excel 2007/2010/2013/2016: Opens the file successfully, but Excel crashes when saving.

Investigation

The workbook contained several images.

• In Microsoft 365 Excel, the images displayed correctly.

• In Excel 2007/2010/2013/2016, the images did not appear and were shown as #VALUE! instead.

The cause was that the images had been inserted using the "Place in Cell" feature, which is only supported in Microsoft 365 and Office 2024.

Because older Excel versions do not support this feature, the workbook becomes incompatible. As a result, not only are the images displayed incorrectly, but even saving changes made in unrelated cells causes Excel to crash.

Resolution

The issue is caused by using the "Place in Cell" image feature, which is not compatible with Excel 2007/2010/2013/2016.

To make the workbook compatible with older versions, replace the "Place in Cell" images with standard inserted pictures before distributing the file. After removing or converting those images, the workbook can be opened and saved normally in older versions of Excel.

DELL idrac 擴充硬碟設定

 

  環境:

Dell server idrc

raid 5

設定過程:

為了增加容量，新增了硬碟。

插入硬碟後，在idrac內，要去"維護"--> "作業隊列"裡面，會出現待執行的工作，就可以看到插入的硬碟，要做何種設定，這邊就可以選擇要擴充到原本的raid中，設定好，這個作業不到幾分鐘就會完成了。。

完成後，在到"儲存"-->"虛擬硬碟"，這邊就可以看到目前的擴充進度。

Environment:

Dell Server
iDRAC
RAID 5

Procedure: Expanding a RAID 5 Virtual Disk

To increase the storage capacity of an existing RAID 5 array, install the new hard drive into the server.

After the drive is installed:

1. In iDRAC, go to Maintenance → Job Queue.
2. A pending job for the newly inserted drive will appear.
3. Select the appropriate operation to expand the existing RAID 5 virtual disk.
4. Apply the configuration.

The configuration job itself typically completes within a few minutes.

Monitoring the Expansion Progress:

After the job has been applied:

1. Go to Storage → Virtual Disks.
2. Select the RAID virtual disk.

You can monitor the RAID expansion (reconfiguration) progress from this page until the operation is complete.

Note: Although the configuration job completes quickly, the actual RAID expansion and background initialization may take several hours depending on the RAID controller, disk capacity, and system workload. During this time, the virtual disk remains available, but performance may be reduced until the expansion is finished.

選擇權網站推薦

 很適合新人入門學習

https://profitvisionlab.com/academy/

Synology active backup for business 即時還原 虛擬機

  環境:

synology Active Backup for Business

透過"即時還原"功能 ，快速還原整台虛擬機

設定過程:

在Active Backup for Business備份的虛擬機，可以全部完整還原到esxi/hyperv主機上，因為要將所有資料還原回去，時間需要比較久。

但今天只要想要測試一下，可以在還原時，選擇"即時還原"。

這樣的話，還原是將synology掛載到esxi上變成一個datastore，所以還原過程不到幾分鐘就完成了。

可以馬上開始使用，但任何資料異動，會另外儲存，不會寫入虛擬機的vmdk中。

測試ok沒問題，就先關機，回到synology Active Backup for Business中，在還原工作裡找到剛剛的那個工作，選擇"取消"，這台虛擬機就會從esxi/hyperv上刪除，datastore也會被卸載，都不需要在esxi/hyperv上做刪除。

Environment:

Synology Active Backup for Business
Instant Restore of a Virtual Machine

Overview:

Active Backup for Business can fully restore a virtual machine to an ESXi or Hyper-V host. Since the entire VM and all of its data must be copied back, a full restore can take a considerable amount of time.

If you only need to quickly test or verify a backup, you can use the Instant Restore feature instead.

How Instant Restore Works:

1. In Active Backup for Business, select the virtual machine and choose Instant Restore.
2. During the restore process, Synology mounts the backup repository to the ESXi or Hyper-V host as a datastore.
3. Because the VM runs directly from the backup storage, the restore process typically completes within a few minutes.
4. The virtual machine can be powered on and used immediately.

Any changes made while the VM is running are stored separately and are not written back to the original VMDK files.

Cleanup After Testing:

Once testing is complete:

1. Shut down the virtual machine.
2. Return to Active Backup for Business.
3. Open the Restore Tasks list.
4. Locate the Instant Restore task and select Cancel.

Active Backup for Business will automatically:

• Remove the virtual machine from the ESXi/Hyper-V host.
• Unmount the temporary datastore.

No manual cleanup is required on the ESXi or Hyper-V host.

synology Active Backup for Business虛擬機備份後 只還原特定檔案

 環境:

synology Active Backup for Business

備份整台虛擬機

異常狀況:

需要還原特定檔案，但不想花時間先還原整台虛擬機

解決過程:

在Active Backup for Business的確是只有整台虛擬機還原的選項。

但可以到Active Backup for Business Portal 裡面，在左上角可以選擇你備份的其中一台虛擬機。

畫面下方就會有時間軸讓你選擇備份的時間點，畫面中間就是每個磁區，你就可以點進去查看裡面所有的檔案，針對需要還原的檔案直接下載到本機中就行了。

Environment:

Synology Active Backup for Business

Virtual Machine Backup

Issue:

You need to restore specific files from a virtual machine backup, but you do not want to spend the time restoring the entire virtual machine first.

Resolution:

Although Active Backup for Business only provides an option to restore the entire virtual machine, you can restore individual files through Active Backup for Business Portal.

1. Open Active Backup for Business Portal.
2. In the upper-left corner, select the backed-up virtual machine.
3. Use the timeline at the bottom of the page to choose the desired backup point.
4. The center pane will display all the virtual disks.
5. Browse the disks to locate the required files or folders.
6. Download the selected files directly to your local computer.

This method allows you to restore individual files without having to restore the entire virtual machine first, saving both time and storage space.

AD匯入admx

 AD裡GPO有些設定不在內建的選單中，但可以透過下載admx檔，增加要透過GPO派送的設定。

以m365 office為例，可以先去下載它的admx檔(https://www.microsoft.com/en-us/download/details.aspx?id=49030)。

下載的時後雖然只有英文版，但下載完，執行後，會將相關的檔案解壓縮在一個資料夾中。

裡面會有admx跟adml檔。

https://www.wisecleaner.com/think-tank/764-How-to-Install-ADMX-and-ADML-for-Microsoft-Edge-Group-Policy-Management.html

windbg 查看 memory dmp檔

環境:

win11

windbg

異常狀況:

用windbg 開啟dmp檔，看不到裡面的log分析。

解決過程:

點選 command browser。

執行 !analyze -v ，就會出現記錄，可以查看是什麼原因造成系統異常。

solidworks 按 del 鍵沒反應

環境:

solidworks

異常狀況:

del 鍵失效，在圖中對任何東西按下del鍵，都無法刪除，沒任何反應

解決過程:

solidworks內對刪除的快速鍵設定不見造成此問題。

從"工具" ->"自定"->"鍵盤"，裡面會有"刪除"的快速鍵可以設定，這邊選擇del鍵，就可以恢復del鍵的刪除功能。

Environment:

SolidWorks

Issue:

The Delete (Del) key stops working.
Pressing the Del key on any object within a drawing or model has no effect, and nothing is deleted.

Resolution:

The issue is caused by the Delete keyboard shortcut assignment being removed or changed within SolidWorks.

To restore the Delete key function:

1. Go to Tools → Customize.
2. Select the Keyboard tab.
3. Locate the command Delete.
4. Assign the Del key as its keyboard shortcut.
5. Apply the changes.

After reassigning the shortcut, the Del key will function normally and can be used to delete objects again.

commvault Alert: Index State Type: Custom Rules - Index State

   環境:

commvault

異常狀況:

突然每天都會收到這個警告信，但備份工作都正常，不知是哪邊有問題。

後來發現這個backupset底下的所有虛擬機備份，在這警告信出現前的備份都可以正常還原。

在開始發出警告信後的備份，還原時都會出現錯誤:Could not perform the operation as Log restore failed for Job 161471. Please check Index Server log for more details。

解決過程:

參考ai上的作法，在commvault主機上的C:\Program Files\Commvault\ContentStore\IndexCache，底下有CvIdxDB跟CvIdxLogs資料夾

在裡面找到跟上面DbName相同名稱的資料夾，把他們改名。

重新建立還原工作，系統就會重建裡面的內容，恢復正常~~但試過沒用。

後來重新啟動完整備份，還是一樣的錯誤。

最後解法就是，建一個新的backupset，在裡面對虛擬機建立新的備份工作，備份完測試，可正常還原。

Environment:

Commvault

Issue:

An alert email suddenly started appearing every day, although all backup jobs were completing successfully and no obvious issues were found.

Further investigation showed that:

• Backups of all virtual machines under this Backupset that were created before the alert emails started could be restored normally.

• Backups created after the alerts began failed during restore with the following error:

Error:
Could not perform the operation as Log restore failed for Job 161471. Please check Index Server log for more details.

Troubleshooting Process:

Based on suggestions found online, the following method was attempted:

1. On the Commvault server, navigate to:
   C:\Program Files\Commvault\ContentStore\IndexCache

2. Locate the folders under CvIdxDB and CvIdxLogs that have the same name as the DbName shown in the error.

3. Rename those folders.

4. Create a new restore job so the system can rebuild the index data.

However, this method did not resolve the issue.

A Full Backup was then executed again, but the restore error still occurred.

Final Resolution:

The issue was resolved by:

1. Creating a new Backupset.

2. Creating a new backup job for the virtual machines within that Backupset.

3. Running the backup again.

After the new backup completed, restore tests were performed and the restore worked normally.

安裝win11 抓不到pcie ssd硬碟。

 環境:

acer主機

Intel 13代 cpu

pcie ssd

異常狀況:

安裝win11，一直抓不到ssd硬碟。

上acer官網找到了irst的驅動，安裝時這個驅動也不支援，還是找不到硬碟。

上intel官網抓到最新一代的irst驅動，卻是exe檔，在win11安裝過程，也沒辦法安裝

解決過程:

intel官網抓到最新一代的irst驅動是exe檔，需在其他台電腦，用powershell指令，去解壓縮，裡面就會有driver這個資料夾。

安裝win11時就可以透過裡面的檔案，載入pcie ssd。

1. 在包含SetupRST.exe檔的目錄中打開終端，方法是右鍵按兩下目錄並在此處選擇「在終端中打開」或「打開 PowerShell」。您可能必須在目錄上按 SHIFT 鍵，才能看到要選擇的正確選項。
2. 透過執行命令 ./SetupRST.exe -extractdrivers SetupRST_extracted 來解壓縮預安裝驅動程式

Environment:

Acer desktop/laptop
Intel 13th Gen CPU
PCIe SSD

Issue:

During Windows 11 installation, the SSD drive is not detected.

The Intel Rapid Storage Technology (IRST) driver downloaded from the Acer support website was loaded during setup, but the SSD still could not be detected.

A newer IRST driver was found on Intel's website, but it was provided as an .exe installer, which cannot be installed directly during the Windows 11 installation process.

Resolution:

The latest Intel IRST package downloaded from Intel's website must first be extracted on another computer.

1. Download the latest SetupRST.exe from Intel.
2. Open a terminal (PowerShell or Command Prompt) in the folder containing SetupRST.exe.
3. Run the following command:

.\SetupRST.exe -extractdrivers SetupRST_extracted

This will extract the pre-installation drivers into a folder named SetupRST_extracted.

To open a terminal in the correct folder:

• Right-click within the folder and select "Open in Terminal" or "Open PowerShell window here".
• On some Windows versions, you may need to hold the SHIFT key while right-clicking to see the appropriate option.

4. Copy the extracted driver files to the Windows 11 installation USB drive.
5. During Windows 11 setup, select Load Driver when choosing the installation disk.
6. Browse to the extracted driver folder and load the IRST driver.

After loading the extracted driver, the PCIe SSD will be detected and Windows 11 installation can proceed normally.