Ver. 2021.5 - Remove link sources, improved processing of SharePoint pages...

New in version 2021.5

  • Added option that ReplaceMagic removes all link sources from your Excel documents:
  • What is new (2021.5)?
    Extended command line run to include filtering of files based on dates:

  • Changed that per default ReplaceMagic will not check-out/check-in documents when processing files on SharePoint. Reason is that if this is done and there is SharePoint throttling which will cause that files are skipped, documents might stay checked-out. In case that you want to to keep publishing or approval status you will need to have this feature enabled.
  • Fixed bug that after SharePoint pages replacements are done published pages are staying in unpublished state (minor version).
  • Sorting of search & replace strings - As sort order of search&replace strings is very import ReplaceMagic will now sort them automatically according to their length descending when you press button to start replacement process or to prepare parameters for command line run. This is required as if you have shorter strings first ReplaceMagic might make changes when shorter string is found and as it is also part of longer search string that might cause that longer string is skipped as changes are already done. This is done in the background to ensure that strings are properly sorted but sort order will not be visible in search and replace form.
    As a indicator, we added new column "Search length" which can be used as indicator to show length of your search strings
  • Extended ReplaceMagic to automatically take care of approval and/or publishing status of documents stored in SharePoint when this setup is used. Previously, user had to select what ReplaceMagic should do.

Ver. 2021.4 - SharePoint pages, special characters and more...

New in version 2021.4

  • There is a chance that Link Sources in Excel files are not visible if you go to Data=>Connection=>Edit Links but that they are still present if you check XML document structure - to support analyses on this side ReplaceMagic will include in Link Source tab additional field called VisibleInExcel which will help to better understand structure of link source stored in documents.
    In case that this field is not visible go to c:\users\username\appdata\roaming\replacemagic or c:\users\username\appdata\local\replacemagic and delete file gridLinkSourcesLayout.xml which will reset result grid fields (btw. this will show default fields order).
  • Added option that ReplaceMagic during replacements in hyperlinks, OLE, Link Sources, Pivot or Power Queries makes replacement of special characters. This is useful in case of documents stored in SharePoint as some migration tools are converting locations of copied documents by replacing special characters.

    Option "Use illegal characters conversion during check of broken links?" will instruct ReplaceMagic to replace special characters when links are checked. This will not make any changes of links.

    Option "Replace SharePoint illegal characters?" will instruct ReplaceMagic to convert illegal characters during replacement process similar to conversion of /and \.

    Special characters are converted in order from 1 to 18 and empty fields are skipped.
  • Extended processing of SharePoint .aspx page where content is part directly of the page. ReplaceMagic will read all tags used in .aspx page and make replacement of them. Previously, only content between <mso:PublishingPageContent></mso:PublishingPageContent> was processed (default SharePoint pages).
  • Fixed bug that silent run processing replacement process did not work.
  • Added parameter to control if ReplaceMagic will automatically close after silent run processing is finished.
  • Fixed bug that when document processing timeout was reached number of active threads was not reduced after closing processed document which could lead that processing is stopped waiting on free processes.
  • Changed that ReplaceMagic in command line mode is closing splash screen before processing documents.

Error - Sorry we can't get to your account right now. To fix this please sign in again. => resolved

This time something different :)

For some reason since weeks I had problem to connect to O365 mailbox. Initially, it stopped work so I decided to remove mailbox from Outlook (2016) and to add it again but that did not work. For whatever reasons, no matter, what I tried Outlook was not able to connect to O365.

Yesterday, it started to be even worse as when I went to SharePoint Online to test processing of documents all was ok and when I tried to open documents in Excel Online that worked too but opening of files through normal version of Excel was not working.

Surprisingly, Excel was telling me that I am already logged from some other machine which was not the case and additionally any Office desktop application was showing error next to username.

By opening this I saw: "Error - Sorry we can't get to your account right now. To fix this please sign in again." and logically, I tried to sign in again but that did not work so I was thinking "great, now beside Outlook, rest of Office apps are not working".

Of course, I did sign-out and then again sign-in but no progress. I even checked my user account under Windows Settings => Access work or school but that did not help.

Ultimately, solution was to go to Office app (I tried Excel) and to sign-out and then to go to Windows Settings => Access work or school where I clicked on Disconnect below my O365 account. After doing restart (not sure if this is really needed) I went to Excel and this time I logged again without any warnings and then I tried to add again my O365 account to Outlook 2016 and that worked.


Ver. 2021.3 - SharePoint processing improvements and more...

What is new in ReplaceMagic 2021.3:

  • SharePoint Online throttling - Recently, we noticed that Microsoft is even more protecting SharePoint Online platform by slowing down processing of documents.
    As during scanning and replacements ReplaceMagic needs to download documents, read document meta data, apply check-in/check-out settings, keep status of documents (approval, publishing) and finally to upload documents and set all meta data back to normal you can see performance degradation. To avoid this move document processing outside of business hours and do not over parallelize processing of documents as otherwise duration of processing can be impacted. Of course, we will try to protect processing but throttling, which is normal to expect, is, unfortunately, outside of our hands.

    Additional infos can be found in article SharePoint Throttling

    In case of skipped documents during replacement phase - Due to those limitations some documents might be skipped but ReplaceMagic offers option to import skipped files and process them after main replacement phase is done. To do that, in newly, shown tab Additional Info click on:

    This can be repeated until not all documents are not processed.

    We would also recommend to split processing on few smaller batches/locations to avoid having processing against large collection of documents at once.
  • SharePoint performance metrics changed to show average processing time per document as previously ReplaceMagic was showing total phase processing time. Average processing time is calculated as total phase time / total processed documents. Those metrics are part of result dashboards.
  • SharePoint Web Logon- sometimes Web Logon authentication might take longer. If this is taking more than 30+ in newly opened popup click on button:

    In case that SharePoint structure is not shown in main SharePoint form please close it and open it again (we are working on this rare refresh problem).
  • Added functionality to create Windows registry entries for creation of Windows dumps if ReplaceMagic is crashing. This can be done over Configuration => Logs

    This will work only if your user has enough Windows permissions.
    Dump files are required for root-cause analyses by ReplaceMagic team and per default they will be stored in C:\Users\USERNAME\Local\ReplaceMagic\CrashDumps.
    Depending on your Windows policies this might not work but we recommend set it anyway.
    IMPORTANT: Do this only on request for ReplaceMagic team
  • Fix bug that in some cases documents on local locations (disks, file servers,...) were skipped.
    Check only XML stored Link Sources - Excel link sources are stored in XML structure under /xl/externalLinks/_rels location but during check if links are broken ReplaceMagic will read this location but also location which is used in Excel if you go to Data => Edit links. To avoid false-positive results, we include feature to disable check of link which is shown in Excel:

    Per default we are checking both location and if one is working ReplaceMagic will report that link is ok.
  • In case that Excel document is moved to new location hard-coded AbsolutePath value will still point to the old location. Absolute path value is used to show link sources if you open Excel document and go to Data => Edit Link. From this version, in case that there are Link Source changes ReplaceMagic will update Absolute Link to point to new location where documents is. This means, when you open Excel file and go to Data => Edit Links you will see link pointing to some URL or drive/network location like where document is stored.
    Fixed bug that was triggering "expired maintenance" when maintenance was still valid.
    "Native SharePoint check of broken links" - extended support for additional case of hyperlinks in list items (field of URL type). Keep in mind that this feature will send additional requests to SharePoint what might increase risk to get throttled by SharePoint.
    Added new tab under Configuration for misc features - "Convert relative to absolute links"  used to define how relative links will be checked. Per default when ReplaceMagic finds relative link, it will merge that link and location of file containing this link which might be misleading in some cases. With this feature you can specify how link should start and what should be prefix but also if slashes has to be converted:

    Additionally, ReplaceMagic can write to log file original address and also address where prefix was added for your reference.
    Keep in that this will have performance impact as due to, probably, large number of links ReplaceMagic will need to write a lot to log files. Of course, this is only active during scanning process.

    Remark: original links will not be impacted by this as this change is used only for check of links without making real changes.
  • Started to add functionality to process SharePoint Quick Launch and Top Menu Bar.

    IMPORTANT: In case that SharePoint cannot recognize new menu link as valid, change will not be saved. Keep in mind that you have to convert menu link to valid link.
    Log files should be now created after any of processing activities (scanning documents or replacement process). Log files are per default saved in c:\users\username\appdata\roaming\replacemagic\logs or in c:\users\username\appdata\local\replacemagic\logs and filename format is: ReplaceMagic - Datum - Time.log (for example,  ReplaceMagic - 13.05.2021 135259.log)
    Fix bug that scanning of .aspx pages (in SharePoint) was reporting more links than pages really have.
    Added encoding/decoding of additional special characters in .aspx pages.
    Extended convert slash/backslash functionality to changes in Excel text area (convert functionality will be applied only on changed cell content).
    Formatting of SharePoint labels in scanning or replacement dashboard adjusted => (SP) moved to second row.
  • Added parameter "Fast Calendar Step" which can be used to set how many months ReplaceMagic calendar will move to the left or right when << or >> are pressed:

  • Added option that ReplaceMagic converts Unicode characters in SharePoint/Web pages:

Ver. 2021.2.1 - SharePoint pages replacement results fix

What is new in ReplaceMagic 2021.2.1:

  • Fixed bug that replacements in SharePoint Wiki or SharePoint Canvas pages are done but not reported in result lists

Ver. 2021.2 - multi user support for SharePoint Online to reduce throttling risk...

What is new in ReplaceMagic 2021.2:

  • New theme added => Office2019Light
  • Fixed bug during processing of SharePoint .aspx pages that no changes are done as encoded : (&#58;) was not properly converted to : leading that no changes of strings containing : were done.
  • Fixed bug (introduced in 2020.12.1) that changes in Canvas and Wiki pages did not work.
  • In case that there is problem during startup of ReplaceMagic new log file ReplaceMagicStartup.log will be created providing information what happened.
  • Added feature to create multiple SharePoint users which will be used to process documents in round-robin model (every document will use next SharePoint user from created list of users). This might be interesting in case of SharePoint throttling as in this case it will look like that there are multiple users accessing and processing documents stored on SharePoint.
  • In case of multi language sites, if ReplaceMagic user is having different language to language used to create site selected for processing, ReplaceMagic was stopping complete processing (probably in progress bar you could see message "Root prepared...)". From this version there is additional notification if something like this happens telling you that you'll need to align user and site language. Of course, additional logging is also provided in Console View or in ReplaceMagic log file.
  • Fixed bug that password protected documents stored on SharePoint, after password was provided, were not processed.
  • Check of broken links when documents are stored on SharePoint might end-up with errors like 403 Forbidden. To avoid that we are introducing parameter "Native SharePoint check of broken links" which will allow ReplaceMagic to use SharePoint object model to check if links are broken or not. Unfortunately, this means that for each of found links ReplaceMagic will send request to link location which will be very "expensive" meaning that processing performances will suffer and there is high risk that, due to high number of SharePoint requests, Microsoft throttle complete processing. Nevertheless, as some customers shown interest in this feature it is included now but you are solely responsible for usage of it thus warning message.
  • Improved error handling when test email sending is triggered from Configuration => Notification

Ver. 2021.1 - Support changes of links in SharePoint Link Summary web part

What is new (2021.1)?

  • Added support for changes of links in Summary Links Store web part

  • Fixed problem that parameters in hyperlinks of Visio documents are duplicated after replacements in links
  • Fixed problem that ReplaceMagic was showing in Search & Replace results also changes of documents where save did not work.







SALE: until end of June, 2021 we offer discounted ReplaceMagic bundle prices. More details over




Ver. 2020.12.1 - SharePoint multi factor authentication improvements and more...

What is new (2020.12.1)?

  • Extended ReplaceMagic configuration to support proxy settings for checking broken http/https links when WinHTTPRequest feature is used. This option is not available when using MSXML check method:

  • Extended filtering on date (creation, modification or access date) to include setting of time also:

  • Fixed problem that in case of list items SharePointURL in Scan Documents tab was not properly shown
  • Improved functionality used for SharePoint Multi-Factor authentication (also renamed it to Web Logon):

  • Remark: It looks like that Web Logon is sensitive to number of documents to be processed in parallel. To avoid throttling or that documents are skipped (it looks like that SharePoint will block some documents resulting that they end-up in Additional Info tab) we are setting maximum parallelism to 4 in case of this authentication mode. In case of throttling, we recommend that you investigate App-Only approach described in article "Granting access using SharePoint App-Only (use when Legacy Authentication mode is not allowed)". If you still want to use higher number of work processes when using Web Logon authentication see next point.
  • Added parameter Ignore Web Logon limit

    Per default ReplaceMagic will not allow parallelism higher than 4 documents in case of Web Logon authentication mode. By setting this parameter this limit will be ignored and ReplaceMagic will use value of parameter "Parallel document processing".
  • Parameter "Processed all skipped documents":

    After replacement process is done in case that there we were some skipped documents ReplaceMagic will allow you to re-try to process them again. To focus reprocessing only on skipped documents inside of Additional Info tab you can find button "Reprocess SharePoint files":

    By clicking on this button ReplaceMagic will set skipped documents for processing. Default setting is to limit reprocessing only to documents skipped due to

    By setting this parameter ReplaceMagic will prepare all skipped documents no matter on error code. As sometimes might happen that documents are skipped (for example, time out error) we recommend that after replacement process is done you try to reprocess skipped documents.

    Remark: In case of Web Logon authentication mode, if you use higher processing parallelism, SharePoint might skip some documents and they will land in Additional Info tab. By using "Reprocess SharePoint files" functionality you can separately try to make replacement in skipped documents.
  • Added support to make changes in texts (including links) of SharePoint Discussion Boards

    To see current limitations of processing list items or discussion board items check following article

  • Introduction of WebLogon brings connectivity improvements which are more and more required. To be able to release this ReplaceMagic version ASAP, focus was to enable processing of documents (core ReplaceMagic functionality) but processing of links in list items for WebLogon was postponed for later. 
    Of course, processing of list item attachments is still possible.
  • Fixed bug that, when CommandLine XML is used, ReplaceMagic was not able to decrypt password.
  • Added progress bar during import of previously scanned documents
  • Before if date fields were not properly formatted for import of scanned files ReplaceMagic was showing error message that file format is not correct. From this version ReplaceMagic will try to adjust wrongly formatted dates and continue with import.
  • New parameter "URL Decode links for link checker" - if link in documents had some special characters, for example é, they were converted to %C3%A9 which was causing that server with this link to return that link is broken even if it should work. With this parameter ReplaceMagic will do URLDecode converting %C3%A9 to é so that link checker can get correct response from the server:

    [REMARK] Due to increase usage of SharePoint Online and other related cloud services, Microsoft is introducing even tighter throttling limits which will be added on the top of normal throttling. Evening and weekend hours should not be impacted but this is not totally clear. In case that you notice slowdown in processing with ReplaceMagic we strongly recommend to reduce number of documents for parallel processing (Configuration -> Configuration tab -> Parameter "Parallel document processing") or to enable parameter "Decrease workload during SharePoint throttling?".


Ver. 2020.10.1 - help with SharePoint throttling and much more....

What is new in 2020.10.1:

  • Fixed issue that if SharePoint App-only authentication mode is selected client secret (password) is not in all places properly used. This authentication mode can be used in case that legacy authentication mode is disabled for your site(s). More details can be found in ReplaceMagic help article "Granting access using SharePoint App-Only (use when Legacy Authentication mode is not allowed)"
  • Updated SharePoint section of help file (SharePoint errors, App-Only authentication, MFA,...)
  • Fixed problem that PowerPoint files are skipped if "Check broken links" is enabled and there are OLE links without any entry in Address field.
  • Per default ReplaceMagic works with parallelism of 5 documents at the same time (parameter "Parallel document process" in Configuration). As newer computers usually have more than 5 threads available, meaning they can process more than 5 documents in parallel, if this number is not increased ReplaceMagic will not optimally use hardware capacity. To go around this we are introducing parameter "Optimize workload ... after every ... documents" which will after defined number of documents try to increase workload to maximum number of available threads:
  • In case of that documents are stored on SharePoint might happen that SharePoint starts to throttle processing. To reduce risk that processing is full stopped by SharePoint (too much workload) you can set ReplaceMagic to reduce parallel document processing when SharePoint starts to throttle accesses to documents. TO set that use parameter "Decrease workload during SharePoint throttling?". In case that ReplaceMagic receives error messages 429 - too many requests it will reduce number of parallel documents for half as long as those error messages are shown. Minimum reduction will be to 1 document at the same time (sequential processing). In case that you want that ReplaceMagic later increase number of parallel documents for processing please select parameter "Optimize workload..."

    Remark: if you have computer with more than 8 threads we do not recommend to use this option without parameter SharePoint safety belt  
  • New parameter "SharePoint workload safety belt" - in case that ReplaceMagic should optimize workload to use maximum what current hardware can do with this parameter we are controlling that when processing is done against SharePoint we do not use more than 8 documents in parallel to reduce risk that ReplaceMagic is throttled by SharePoint. In case your hardware has more than 8 threads and you are using "Optimize workload..." we are recommending to using this parameter:

  • Fixed problem with mm/dd/yyyy format and license file
  • In case that during replacement process with documents stored in SharePoint some of them are skipped due to following error codes:

    Document bigger than set limit
    Document processing manually stopped
    Document processing timeout reached
    Error code 429 => SharePoint Throttling
    Error code 503 => SharePoint Throttling

    you will have possibility to prepare them for reprocessing immediately after initial replacement process is done by simple click on one button.
    1. When replacement process is done in dashboard you will see how many documents are skipped:

    2. If you click on Additional Info tab

    You will see all documents that are skipped with reasons why.
    In case that you see documents with above mentioned errors by clicking on "Reprocess SharePoint files" ReplaceMagic will create collection of only those documents which you have to process immediately by going to Search & Replace tab where you will run everything exactly the same.

    1. In case that documents where skipped due to document size they will be skipped again except if you do not change maximum size of file. See Configuration => parameter "Skip files bigger than"
    2. If documents were skipped due to timeout to be able to process them you will need to increase timeout parameter. See Configuration => parameters "Maximum time to process document" and "Wait time to close document processing".
    3. If documents were skipped due to SharePoint throttling (errors 429 and/or 503) there are two options:
    a). reduce number of documents to be processed in parallel => see Configuration => parameter "Parallel document processing". As a smaller helper you can also use "Decrease workload during SharePoint Throttling"
    b) Wait with processing few hours to allow that SharePoint lifts throttling limits. Please do not close ReplaceMagic as skipped files will be also gone.

    In case of option 1 we would recommend to set parameter "Parallel document processing" to 1 so that documents are sequentially process one by one. In case that SharePoint allows that you enable parameter "Optimize workload" as that will increase number of documents for parallel process for one every X documents. Please keep in mind that parameter "SharePoint workload safety belt" is also enabled.

    "Reprocessing SharePoint files" is visible only when selected scan location starts with http(s).

    Additional remark - you can repeat "Reprocess SharePoint files" after each replacement process, basically, as long as you do not have any document skipped with above mentioned error messages.


Ver. 2020.9.1 - improvements in processing Excel files and more...

Focus of this updates are improvements related to processing of Excel files like:

  • In Excel documents under Link Sources there might be link sources that are visible over Data => Connection and Link Sources which are hidden. Previously, ReplaceMagic was showing all Link Sources which is now changed that ReplaceMagic shows only visible Link Sources. In case that you want to see all Link Sources go to Configuration => Processing and select parameter "Show all Excel Link Sources". Only shown Link Sources will be used later for replacements
  • Extended Link Source result list to include indicator if link source (Excel: Data => Edit Links) is used somewhere in Excel file or not
  •  Improved usage of regular expressions when search string starts with reserved character
  • Further improvements...